將文本內(nèi)容導(dǎo)入mysql數(shù)據(jù)庫中導(dǎo)入語句加入字符集，否則亂碼 character set gbk;因?yàn)閚ame列加了唯一索列，加這個(gè)是為避免重復(fù)數(shù)據(jù)插入報(bào)錯(cuò) ignore into table把相同的先刪除掉 replace into table[linux] 這里關(guān)鍵load data infile '/tmp/t0.txt' ignore into table t0 character set gbk fields terminated by ',' enclosed by '"' lines terminated by '\n' (`name`,`age`,`description`);[windows] load data infile 'f:/2.txt' ignore into table t0character set gbk fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`name`,`age`,`description`);CREATE TABLE `t0` (`id` bigint(20) unsigned NOT NULL auto_increment,`name` char(20) NOT NULL,`age` tinyint(3) unsigned NOT NULL,`description` text NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk;導(dǎo)入的文件 2.txt"我愛你1","201","相貌平常，經(jīng)常耍流氓！哈哈" "我愛你2","202","相貌平常，經(jīng)常耍流氓！哈哈" "我愛你3","203","相貌平常，經(jīng)常耍流氓！哈哈" "我愛你4","204","相貌平常，經(jīng)常耍流氓！哈哈"

?

轉(zhuǎn)載于:https://www.cnblogs.com/kaka100/archive/2013/03/07/2947337.html

總結(jié)

以上是生活随笔為你收集整理的mysql_load的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。