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]