Re: Can't Show Warnings
For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Show Warnings
Hi Randy, 4.1.1 hasn't been released yet unfortunately. The devs have said that they've started release testing or whatever it's called. I think they said it will hopefully be released in 4-6 weeks. :-) Matt - Original Message - From: Randy Chrismon Sent: Thursday, September 18, 2003 5:39 PM Subject: Re: Can't Show Warnings For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Show Warnings
Randy Chrismon [EMAIL PROTECTED] wrote: For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? You can install it from development source tree: http://www.mysql.com/doc/en/Installing_source_tree.html or wait when binaries will be available. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't Show Warnings
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. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Show Warnings
At 1:43 PM -0400 9/18/03, Randy Chrismon wrote: 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]