これをsjis変換して取込むコマンド(mysqlを利用)
use test;
set character_set_database=sjis; #このコマンドでデータをsjis変換#
LOAD DATA LOCAL INFILE \"/test/data.csv\" INTO TABLE test_db1 FIELDS TERMINATED BY ',' IGNORE 1 LINES;
use test;
set character_set_database=sjis; #このコマンドでデータをsjis変換#
LOAD DATA LOCAL INFILE \"/test/data.csv\" INTO TABLE test_db1 FIELDS TERMINATED BY ',' IGNORE 1 LINES;
use test; set character_set_database=sjis; #このコマンドでデータをsjis変換# LOAD DATA LOCAL INFILE \"/test/data.csv\" INTO TABLE test_db1 FIELDS TERMINATED BY ',' IGNORE 1 LINES;