after executing command. use the below command to know the warnings it is throwing
mysql> show warnings; Thanks Anil -----Original Message----- From: Qunfeng [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:45 AM To: Paul DuBois; mysql@lists.mysql.com Subject: Re: myql command-line no warning :-) 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
