Why my query ‘REPLACE INTO…’ does not work?
To insert or update data if data exists, I was using ‘REPLACE INTO…’ in a var $query_string
like this :
dbdelta
CREATE TABLE with dbDelta does not create table
I based this code from the codex on the docs. I placed it in my main plugin file but it’s not creating the database table. Have I missed something?
Does dbDelta delete columns as well?
I created a table using the dbDelta function and then removed a few columns and added a few. The new columns did get created but the old columns did not get deleted from the table.