Re: Can't Show Warnings

2003-09-19 Thread Randy Chrismon
 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

2003-09-19 Thread Matt W
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

2003-09-19 Thread Victoria Reznichenko
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

2003-09-18 Thread Randy Chrismon
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

2003-09-18 Thread Paul DuBois
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]