RE: Pulling large Microsoft SQL files into MySQL

2003-07-15 Thread Miguel Perez
Hi: Or you can use a DTS to transfer the info to MySQL Greetings From: "Ralph Guzman" <[EMAIL PROTECTED]> To: "'Rudolf Bekker'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: Pulling large Microsoft SQL files into MySQL Date: Tue, 15 Ju

RE: Pulling large Microsoft SQL files into MySQL

2003-07-15 Thread Ralph Guzman
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n'; You can find more on this at: http://www.mysql.com/doc/en/LOAD_DATA.html -Original Message- From: Rudolf Bekker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 2:

RE: Pulling large Microsoft SQL files into MySQL

2003-07-14 Thread Ralph Guzman
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n'; You can find more on this at: http://www.mysql.com/doc/en/LOAD_DATA.html -Original Message- From: Rudolf Bekker [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 5:13