:-) I see. Thanks! It w(not vv)orks!!!
Qunfeng
At 10:48 PM 12/21/2004, Paul DuBois wrote:
At 20:44 -0600 12/21/04, Qunfeng wrote:Paul,
Thanks for your reply. I tried
mysql -p -w DB < test.sql
still no warning.
I tried -vw it simply echo the sql statement, no warning.
I didn't suggest using -w or -vw. I suggested -vv (two v's) or -vvv (three -v's).
Qunfeng
At 05:45 PM 12/21/2004, Paul DuBois wrote: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]
