List:General Discussion« Previous MessageNext Message »
From:kalin mintchev Date:December 10 2004 3:46am
Subject:RE: Deleted: 0 Skipped: 0 Warnings: a lot
View as plain text  
> I have never had a problem running that command, however you do have to
> run it right after you run
> your query (or LOAD DATA). That may be why you can't use it.

that's what i did. here, this is straight from the cl of the mysql client:

Query OK, 415 rows affected (0.01 sec)
Records: 415  Deleted: 0  Skipped: 0  Warnings: 125

mysql> show warnings;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'warnings' at line 1


>
> Also, try looking under <HOSTNAME.ERR> instead of a log file. That might
> help out.

there is no such file on this machine...


thanks....

>
> J.R.
>
> -----Original Message-----
> From: kalin mintchev [mailto:kalin@stripped]
> Sent: Thursday, December 09, 2004 7:29 PM
> To: J.R. Bullington
> Subject: RE: Deleted: 0 Skipped: 0 Warnings: a lot
>
>
>> Command is SHOW WARNINGS;
>>
>> You can run this from either the command line or from the MySQL CC SQL
>> viewer.
>
> thanks..  but from the command line i get:
> Check the manual that corresponds to your MySQL server version for the
> right syntax to use near
> 'warnings' at line 1
>
> is mysql-standard-4.0.13 to old for show warnings!?
>
>
>
>>
>> J.R.
>>
>> -----Original Message-----
>> From: kalin mintchev [mailto:kalin@stripped]
>> Sent: Thursday, December 09, 2004 6:53 PM
>> To: mysql@stripped
>> Subject: Deleted: 0 Skipped: 0 Warnings: a lot
>>
>> hi all...
>>
>> where can i see what these warnings are. i get them when i do load
>> data infile.
>> i was looking for some kind of log under /var/logs/ or mysql/var/log
>> but there isn't a log file for mysql at any of those locations. and
>> the mysql/var/ doesn't exist at all.
>> i created it and redid the load but still no log file..
>>
>> is there a way to read the binary log files...
>>
>> thanks...
>>
>>
>>
>> --
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>
> --
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


--

Thread
Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotJ.R. Bullington10 Dec
    • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
RE: Deleted: 0 Skipped: 0 Warnings: a lotJ.R. Bullington10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec
    • Re: Deleted: 0 Skipped: 0 Warnings: a lotDan Nelson10 Dec
  • RE: Deleted: 0 Skipped: 0 Warnings: a lotkalin mintchev10 Dec