MySQL - how to drop table only if exists?

1 answers

0 points

Asked by:

457

How can I drop the table in MySQL only if it exists?

1 answer

0 points

Answered by:

457

I found a solution:

We can use the following syntax so we won't get errors while trying to drop a table that doesn't exist:

DROP TABLE IF EXISTS `table_name`;

Check the article below to see some practical examples:

0 comments Add comment

Get your tech brand or product in front of software developers.

For more information Contact us

Join