List:General Discussion« Previous MessageNext Message »
From:lists.mysql-users Date:June 30 2005 9:14pm
Subject:Re: load data infile
View as plain text  
Hallo,

Op 30 Jun 05 schreef blackwater dev aan mysql@stripped:

 bd> "1","23","345","45";
 bd> "34","4","444","1er";
 bd> Load data local infile '/httpd/htdocs/sql/loader.sql' into table
 bd> vehicles fields terminated by ',' enclosed by "'" lines terminated by
 bd> ';'

I think it should be: enclosed by '"'

Groetjes,

           Hans.

jdh punt beekhuizen bij duinheks punt xs4all punt nl

--- GoldED+/LNX 1.1.5/040412
 * Origin: The Wizard is using MBSE/Linux (2:280/1018)
Thread
load data infileblackwater dev30 Jun
Re: load data infilelists.mysql-users30 Jun
RE: load data infileMartijn van den Burg1 Jul