- LOAD DATA INFILE 'F:\\am_mp3\\\\data.txt' IGNORE INTO TABLE music.album CHARACTER SET utf8 FIELDS TERMINATED BY ',' lines terminated by '\\r\\n' (album_id,album_name,singer_name,publish_time,song_count);
- --该片段来自于http://www.codesnippet.cn/detail/150720134597.html
来源: http://www.codesnippet.cn/detail/150720134597.html