Hello all,
I have a file where the data looks like this:
"1","23","345","45";
"34","4","444","1er";
I am then trying to load that data using the load data local infile
and this statement:
Load data local infile '/httpd/htdocs/sql/loader.sql' into table
vehicles fields terminated by ',' enclosed by "'" lines terminated by
';'
The rows in loader.sql contain all of the columns so I am not
specifiying the columns and when I run this it tells me it loads 258
rows yet when I look in the db, these rows aren't there.
What am I doing wrong?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
