I'm confused by the method for upgrading a database table in a custom plugin as described here:
Why do they suggest using "CREATE TABLE" for upgrading the database associated with your plugin if you already have a table? Won't that cause MYSQL errors because the table already exists? Shouldn't I use "ALTER TABLE" to make the changes instead? I see the same "CREATE TABLE" on other WordPress tutorials, but no real explanation. Every non-wordpress example I've found of upgrading a DB table tells you to use "ALTER TABLE."
I assume I'm misunderstanding how the upgrade process works in WordPress and I'm really confused.
Thanks for any clarification.