"jsmurthy" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Iam facing the problem in MySql "Load infile"
> MySql - Version 4.0.12
>
> The following is the query iam using and the fields in the flat file are
> separated by character ^G.
>
> LOAD DATA INFILE "/home/dbmigration/migration130_160/ttt.dat"
> table1(one,two,three) FIELDS TERMINATED BY '^G';
>
> 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
> 'table1(one,two,three) FIELDS TERMINATED BY '^G'' at line 1
>
>
Please look at the correct syntax of LOAD DATA INFILE:
http://www.mysql.com/doc/en/LOAD_DATA.html
and check your statement.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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]
