> 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:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] >> Sent: Thursday, December 09, 2004 6:53 PM >> To: [EMAIL PROTECTED] >> 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/[EMAIL PROTECTED] >> >> >> >> -- >> 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] > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
