Pages

Oct 6, 2018

[HDGEM] Example of importing/loading data into MySQL from MySQL client command line

mysql --login-path=live dyn <<SQL
load data local infile 'hdgem.csv' ignore into table dyn.i88_ca fields terminated by ',' OPTIONALLY ENCLOSED BY '"'  ignore 1 lines;
quit
SQL

OR

mysql --login-path=live -e "load data local infile 'hdgem.csv' ignore into table dyn.i88_ca fields terminated by ',' OPTIONALLY ENCLOSED BY '\"'  ignore 1 lines;"

The first option doesn't need to escape ' or ".



--
Posted By Blogger to HDGEM at 3/13/2017 12:53:00 PM

QuickBooks Self-Employed

Bigger tax refunds. Better organization. Manage your deductions with QuickBooks Self-Employed .