CODEWITHSUNDEEP
mysql
marcell
marcell

Reputation: 1

error message of the drop table message

I use

DROP TABLE IF EXISTS `mydb`.`mytable`;

to delete an existing table, the table is deleted, but got the following feedback

Query OK, 0 rows affected, 1 warning (0.00 sec)

Why I am getting a warning messages?

Upvotes: 0

Views: 102

Answers (1)

bgs
bgs

Reputation: 3213

In mysql statement like Drop Table if exists NO_SUCH_TABLE will create warnings, so that's a likely cause in a script like this.

So don't worry about this.

Refer below links to know detailed:

How do I show a MySQL warning that just happened?

Upvotes: 2

Related Questions