I made a table using mySQL and it works perfect, until I decided to remove one line of code, and then the whole thing crashed. My solution was to create a completely new table, without that line of code. I attempted the duplication and removing that line of code, and that did not work either. What I was attempting to do was something along the lines of having "city, state, zip code, country" I decided after making the table that I would remove the "country" portion of it since everything is in the US and it kept crashing.
When you are using MySQL based tables it is not recommended to change the number of columns by adding/removing columns from MySQL query. If you want to add/remove columns you will have to recreate table from scratch. You can replace one column with another one, but it is not possible to change the number of columns in already created table.
I made a table using mySQL and it works perfect, until I decided to remove one line of code, and then the whole thing crashed. My solution was to create a completely new table, without that line of code. I attempted the duplication and removing that line of code, and that did not work either. What I was attempting to do was something along the lines of having "city, state, zip code, country" I decided after making the table that I would remove the "country" portion of it since everything is in the US and it kept crashing.
Hi Yasir,
Thank you for your purchase.
When you are using MySQL based tables it is not recommended to change the number of columns by adding/removing columns from MySQL query. If you want to add/remove columns you will have to recreate table from scratch. You can replace one column with another one, but it is not possible to change the number of columns in already created table.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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