mysqlの場合、phpmyadminのインポートで簡単にCSVを取り込むことができますが、とりあえず。
load data local infile “/~.csv” into table tablename fields terminated by ‘,’;
load data (local) infile “/~.csv” into table tablename fields terminated by ‘,’ enclosed by ‘”‘ lines terminated by ‘rn’;
文字コードを指定しておく場合
set character set utf8;