1. If you create manual tables, the plugin creates a hidden wdt_ID field, which is used to assign row numbers to the table. That column is a unique auto-integer column, so if you have 10 rows, delete row #5, other row numbers will not shift up, but they will be left with 1, 2, 3, 4, 6, 7, 8, 9 and 10, and the next row ID will be 11.
2. The plugin can only be used for pulling the data from the database, using SELECT function, but it cannot create new tables in the database.
Hi
1. Is there a way to add an autonumber field to the table ?
2. Does it support creating MySQL procedures ?
Thanks for your help.
Regards
Anand
Hello Anand
Thank you for your interest in our plugin.
1. If you create manual tables, the plugin creates a hidden wdt_ID field, which is used to assign row numbers to the table. That column is a unique auto-integer column, so if you have 10 rows, delete row #5, other row numbers will not shift up, but they will be left with 1, 2, 3, 4, 6, 7, 8, 9 and 10, and the next row ID will be 11.
2. The plugin can only be used for pulling the data from the database, using SELECT function, but it cannot create new tables in the database.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables