Here's a snapshot from a mysql environment:
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/miamibilling-Cash.txt' -> REPLACE INTO TABLE ln_cash -> FIELDS TERMINATED BY '|' -> ENCLOSED BY '~' -> LINES TERMINATED BY '\r\n' -> ; Query OK, 16374 rows affected (20.83 sec) Records: 16374 Deleted: 0 Skipped: 0 Warnings: 69
mysql> show warnings; Empty set (0.00 sec)
What am I doing wrong that I can't find out what the 69 warnings are? I'm using 4.1.0 alpha.
For LOAD DATA, it works better in 4.1.1, as indicated here:
http://www.mysql.com/doc/en/SHOW_WARNINGS.html
Thanks.
Randy
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]