¹ØÓÚTXTÎļþµ¼ÈëMYSQLÎÊÌâ
Ö÷ÒªÇé¿öÈçÏ£º
ÏÖÓÐÒ»Îı¾Êý¾ÝÎļþ£¬ÀïÃæµÄÊý¾ÝÈçÏ£º
abc 123
def 223 2 wwww
uuu 456 5 xxx
¡¡
Êý¾ÝÓм¸wÌõ Ò»ÐÐ×î¶à4ÁÐ µ«ÊÇ3£¬4Á½ÐпÉÄÜûÓУ¬Îª¿Õ¸ñ
¹ØÓÚÕâ¸öÎļþ£¬ÎÒÔõôµ¼È룬Çë¸ßÊÖÖ¸µã£¬Ç뾡Á¿Ïêϸ˵Ã÷¡£
PS£ºload data infile ÎÒÑо¿¹ý ûÓдËÀàÓï·¨ ÁÐÉèÖÃȱʡҲûÓÃ
½²Îļþµ¼ÈëtxtÎı¾
²éÕÒÌæ»» ¿Õ¸ñΪ /N
load data local infile
SQL code:
mysql> load data local infile 'D:\\csdn.txt' into table t
-> fields terminated by ' '
-> lines terminated by '\r';
Query OK, 4 rows affected, 2 warnings (0.03 sec)
Records: 4 Deleted: 0 Skipped: 0 Warnings: 1
mysql> select * from t;
+---------+------+------+--------+
| name | num | type | net |
+---------+------+------+--------+
| abc | 123 | 0 | NULL |
|
dee | 223 | 2 | www |
|
uuu | 456 | 5 | xxx |
|
uudkdu | 456 | 5 | xxxxxx |
+---------+------+------+--------+
4 rows in set (0.00 sec)
Ö±½ÓÓÃload data infile¾Í¿ÉÒÔ´¦ÀíÁË¡£¹À¼ÆÄãÉÏÃæÖ÷Òª´¦ÀíºÃÄãµÄÁзָô·û¾ÍÓ¦¸Ã¿ÉÒÔÁË£º
SQL code:
load data local infile 'Îļþ·¾¶' into table ±íÃû fiel
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ
ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ
Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......
±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿
redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË
²»¹ý±¾ÈË»¹ÊÇÍÆ¼öʹÓð²×°µÄ°æ±¾
ÒýÓÃ
ÎÒ¿´Á ......