I hope you mean that the SHOW WARNINGS statements follow the DDL statements.
If the DROP statements have the IF EXISTS modifier, then there should not be
any warnings shown in the output. If there are, something (less severe than
an outright error) is wrong with the CREATE statement. It might be some kind
of type coercion, or who knows what, but it should be investigated.
>From: Artie Ziff [mailto:artie.ziff@stripped]
>Sent: Monday, July 13, 2009 8:20 PM
>Subject: show warnings;
>I am returning to mysql after long break, so not experienced with
>details. I inherited a text file with the mysql DDL statements which
>create database and tables, etc. Each 'create' or 'drop' table statement
>is preceded with a 'show warnings' statement. Since this file is used to
>initialize a new database in mysql server, is there any reason to have
>warnings enabled like this? It seems the warning would be generated 100%
>of the time since the database did not exist before. So, my question is,
>is there some good reason to include 'show warnings' statements into a
>file that is intended to initialize a database that did not exist
>before? It seems unnecessary however perhaps there is some situation
>where this makes sense.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1