At 17:43 -0600 12/21/04, Qunfeng wrote:
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?
Try increasing the verbosity level, for example, with -vv or -vvv.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]