I kept extra columns, column names - extra1, extra2 and extra3 in two tables - table_17 and table_18. Later I had to do a JOIN of table_17 and table_18.
After joining, obviously columns extra1, extra2 and extra3 from table_18 are not visible in the "Complete columns list" modal. Because the columns names are duplicate.
As of now there is no data in the tables. So will it be safe to rename the columns in table_18 to extra4, extra5 and extra6 ? Or it's better to recreate a fresh table for table_18 and then rename the columns?
Database column names need to be different. You can change the display header of a column through wpDataTables, but that will not affect the database name of the column.
So, maybe it'd be better to recreate a fresh table and rename the columns.
Hello Aleksandar
I kept extra columns, column names - extra1, extra2 and extra3 in two tables - table_17 and table_18.
Later I had to do a JOIN of table_17 and table_18.
After joining, obviously columns extra1, extra2 and extra3 from table_18 are not visible in the "Complete columns list" modal.
Because the columns names are duplicate.
As of now there is no data in the tables.
So will it be safe to rename the columns in table_18 to extra4, extra5 and extra6 ?
Or it's better to recreate a fresh table for table_18 and then rename the columns?
Best wishes
Srinath
Hello Srinath
Database column names need to be different. You can change the display header of a column through wpDataTables, but that will not affect the database name of the column.
So, maybe it'd be better to recreate a fresh table and rename the columns.
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