ALTER TABLE IF NOT EXISTS throws an error?

Question

MySQL

ALTER TABLE table ADD COLUMN IF NOT EXISTS name
Tell me why it gives an IF NOT EXISTS error, there are no errors on the localhost, but an error on the server.
Is there a replacement IF NOT EXISTS, if there is a name structure in the table table, then skip it, if it is not there, add it

Answer 1

Method

ADD COLUMN IF NOT EXISTS

only implemented in MariaDB but does not exist in MySQL 5-8.
So it looks like you have MariaDB on your localhost and MySQL on the server.
To check the exact database version, run: In SQLize.online you can test your query against different databases.
SELECT VERSION();