...
Code Block | ||||
---|---|---|---|---|
| ||||
LOAD DATA LOCAL INFILE '/home/xxx/data.csv' INTO TABLE mydb.mytable -- make sure the table name is correct! FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (@id, field_a, field_b, @flag, @filetime) SET id = @id+10000, filetime = FROM_UNIXTIME(@filetime), flag=IFNULL(@flag,0); |
Refer to mysql.com and syntax for more details.
Panel | ||
---|---|---|
| ||
Ubuntu 10.10 |