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 ‘”‘;

Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

© 2024 Falco Tech Blog Suffusion theme by Sayontan Sinha