Right now we try to add a new field to a MYSQL table but we want to check if the same field in the target table exists before we add it to avoid error message, I check from some web site (http://stackoverflow.com/questions/5069611/add-column-if-none-exists-in-mysql
) it suggest:
alter table <table name> ADD IF NOT EXISTS NEW_CITY_ID bigint(19) ;
it use if not exists
but it seems MysQL see syntax error.
What should it be?
or MysQL can't do it.