CODEWITHSUNDEEP
mysqlsql
Jumper
Jumper

Reputation: 129

mysql: alter tablename only if table exists

I tried writing query using exists, but no success so far. Searching hasn't helped so far.

Upvotes: 0

Views: 4196

Answers (1)

TehShrike
TehShrike

Reputation: 10074

If you attempt to alter a table that does not exist, the query will fail with an error: Table 'database.table' doesn't exist

MySQL does support ALTER IGNORE TABLE, but that only turns errors into warnings if you're attempting to create a unique index while there are values in the table that violate that index.

If you would like to make sure that you do not produce any database queries, I would suggest ensuring the table's existence using SHOW TABLES LIKE 'tablename' before running your ALTER TABLE query.

Upvotes: 2

Related Questions