Mysql LOAD DATAÃüÁîµÄÏà¹ØÊÂÏî
1.ÔÚWINDOWÏ£¬¼Ç¼Êý¾ÝµÄÎı¾Îļþ±ØÐë²»ÄÜÒÔÖÐÎÄÃüÃû£¨ÃüÁîÐнçÃæÎÞ·¨ÊäÈëÖÐÎÄ£©£¬ÇÒÐè±£´æÔÚ´ÅÅ̸ùĿ¼Ï¡£
2.×Ö¶ÎÖµÖ®¼ä±ØÐëÒªÒÔLOAD DATAÃüÁîÖÐÖ¸¶¨µÄ·Ö¸ô·û·Ö¸ô£¬Ä¬ÈÏΪTAB£¬·ñÔò²»Ê¶±ð£¬Ôì³É¸Ã×Ö¶ÎֵΪNULL¡£
3.ֵΪ¿ÕµÄ×ֶΣ¬ÔÚÎı¾ÎļþÀï¿ÉÒÔÉèΪ¿Õ£¬Ò²¿ÉÒÔÉèΪ\N.
4.WINDOWÏ£¬²»¼Ó"LINES TERMINATED BY '\r\n'"Ò²ÄܲåÈë³É¹¦Ö®¡£
Ïà¹ØÎĵµ£º
MysqlÖÐlimitµÄÓ÷¨£ºÔÚÎÒÃÇʹÓòéѯÓï¾äµÄʱºò£¬¾³£Òª·µ»ØÇ°¼¸Ìõ»òÕßÖмäij¼¸ÐÐÊý¾Ý£¬Õâ¸öʱºòÔõô°ìÄØ£¿²»Óõ£ÐÄ£¬mysqlÒѾΪÎÒÃÇÌṩÁËÕâÑùÒ»¸ö¹¦ÄÜ¡£
SELECT * from table LIMIT [offset,] rows | rows OFFSET offset
LIMIT ×Ó¾ä¿ÉÒÔ±»ÓÃÓÚÇ¿ÖÆ SELECT Óï¾ä·µ»ØÖ¸¶¨µÄ¼Ç¼Êý¡£LIMIT ½ÓÊÜÒ»¸ö»òÁ½¸öÊý ......
mysql> flush privileges;ʲôÒâ˼£¿
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
´ð:
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......
/**********************************
APACHE
***********************************/
±à¼²ÎÊý£º
./configure" \
"--prefix=/usr/local/apache" \
"--enable-so" \
"--enable-ssl" \
"--enable-mods-shared=most" \
"--with-mpm=event" \
"--with-ssl=/usr/local/openssl" \
"--enable-cache" \
"--enable-mem- ......
ǰЩÌì¿´ÁËÀî¸Õ<struts2+hibernate+spring>ÄÇÊéÉϵÄhibernate£¬ÅäÖÃÎļþÒ²Êǰ´ÕÕÉÏÃæÇýøhibernate.cfg.xmlÎļþµÄ£¬Student.javaÅäÖõÄStudent.hbm.xmlÎļþ¾õµÃҲûʲôÎÊÌ⣬µ«²»Öªµ½Ôõô»ØÊ¾ÍÊDZ¨ connection can not open¡£ÓôÃÆ°¡£¬ºóÀ´ÎҾͰÑÊéÀïÃæµÄÅäÖÃÎļþºÍÔ´Â룬¸´ÖƵ½MyEclipseÏÂÃæµÄÒ»¸öÐÂwebÏîÄ¿ÖУ¬ÔËÐ ......
£¨1£©»ñÈ¡MysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂëºÍÊý¾Ý¿âÓû§Ãû
£¨2£©ÉÏ´«ÌáȨphpľÂí£¬Í¨¹ýÁ¬½Ó3389¿ÉÒÔÖªµÀ·þÎñÆ÷ÊÇ2003ϵͳ
£¨3£©udf.dll¶ÔÓ¦²Ù×÷ϵͳ
C:\Winnt\udf.dll 2000
C:\Windows\udf.dll 2003
£¨4£©ÉèÖÃÏàÓ¦µÄ·¾¶ºóÖ±½Óµ¼³ö¡£
£¨5£©Ö´ÐÐÒÔÏÂÃüÁî
create function cmdshell returns string soname 'udf ......