3月 132010
mysql -u user database_name –local-infile= -p -h mysql2XX.db.sakura.ne.jp’
set names utf8;
LOAD DATA LOCAL INFILE ‘./temp.csv’
INTO TABLE user_table_name
FIELDS TERMINATED BY ‘\t’
OPTIONALLY ENCLOSED BY ‘”‘;
mysql -u user database_name –local-infile= -p -h mysql2XX.db.sakura.ne.jp’
set names utf8;
LOAD DATA LOCAL INFILE ‘./temp.csv’
INTO TABLE user_table_name
FIELDS TERMINATED BY ‘\t’
OPTIONALLY ENCLOSED BY ‘”‘;