Hi,

I am using mysql 4.1 on linux.

When I execute an mysql command (e.g., UPDATE statement) at the mysql prompt, it gives me warning if something is not running correctly.
e.g.,
mysql> update testTable set col='abcd' where col='ab';
Query OK, 0 rows affected (0.0 sec)
Rows matched: 2 Changed: 0 Warnings: 2



However, if I put the same command into a file and run mysql command-line, no warning or any message was given. I have no idea if there is anything wrong or how many records got changed.
$ mysql -p DB < test.sql


Is there any way I can show the warning and message?

Thanks!

Qunfeng


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to