MySQL text_fieldsÓï¾äÎÊÌâ.

¿ÉÄÜÎÒµÄÎÊÌâ±È½Ï¼òµ¥ µ«ÊDZϾ¹ÎÒÊÇÒ»¸ö³õѧÕß.ËùÒÔÇë¸÷λ´ó´ó¿ÉÒÔ˵µÄÏêϸЩ..

win7Ï mysql°æ±¾ÊÇ5.1.40

ÎÒÓöµ½ÈçÏÂÎÊÌâ.. ÎÒÏ뽫һ¸öbook.txtµ¼ÈëÊý¾Ý¿â..book.txtÄÚÈÝÈçÏÂ

isbn|title|author last|author first|copyright date|
067973452|notes from underground|dostoevsky|Fyodor|august 1944|

ÒòΪÎÒ½¨Á¢µÄauthorsµÄ±í Ö»ÓÐauthor_id  author_last author_first  country ÕâËÄÁÐ

ʹÓÃÓï¾äÊÇ:
load data infile 'd:/book1.txt' replace into table authors
fields terminated by '|' lines terminated by '\r\n'
text_field (col1, col2, col3, col4, col5)
set author_last = col3, author_first = col4
ignore col1, col2, col5, 1 lines;

±¾ÒâÊǺöÂÔauthors±íÖв»´æÔÚµÄÏî. Ö»µ¼Èëauthor_lastºÍauthor_first µ«Êdzö´í..ÇëÎÊÕýÈ·µÄÓï¾äÓ¦¸ÃÊÇÔõÑùµÄÄØ?

---

½¨ÒéÈ¥mysql°æÎÊÎÊ

---

ÒýÓÃ

½¨ÒéÈ¥mysql°æÎÊÎÊ

¿ªÊ¼Ã»ÕÒµ½..ÒÔתÒÆ..лл~

---

²Î¿¼ÊÖ²áÖеÄÀý×Ó¡£ ÓÃÁÙʱ±äÁ¿£¬²»ÊÇ ignore

SQL code:
LOAD DATA INFILE 'file.txt'
INTO TABLE t1
(column1, @dummy, column2, @dummy, column3);


MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

---

¸Ðл acmain_chmµÄ»Ø´ð..