Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Mysql LOAD DATAÃüÁîµÄÏà¹ØÊÂÏî

1.ÔÚWINDOWÏ£¬¼Ç¼Êý¾ÝµÄÎı¾Îļþ±ØÐë²»ÄÜÒÔÖÐÎÄÃüÃû£¨ÃüÁîÐнçÃæÎÞ·¨ÊäÈëÖÐÎÄ£©£¬ÇÒÐè±£´æÔÚ´ÅÅ̸ùĿ¼Ï¡£
2.×Ö¶ÎÖµÖ®¼ä±ØÐëÒªÒÔLOAD DATAÃüÁîÖÐÖ¸¶¨µÄ·Ö¸ô·û·Ö¸ô£¬Ä¬ÈÏΪTAB£¬·ñÔò²»Ê¶±ð£¬Ôì³É¸Ã×Ö¶ÎֵΪNULL¡£
3.ֵΪ¿ÕµÄ×ֶΣ¬ÔÚÎı¾ÎļþÀï¿ÉÒÔÉèΪ¿Õ£¬Ò²¿ÉÒÔÉèΪ\N.
4.WINDOWÏ£¬²»¼Ó"LINES TERMINATED BY '\r\n'"Ò²ÄܲåÈë³É¹¦Ö®¡£


Ïà¹ØÎĵµ£º

MysqlÖÐlimitµÄÓ÷¨Ïê½â


MysqlÖÐlimitµÄÓ÷¨£ºÔÚÎÒÃÇʹÓòéѯÓï¾äµÄʱºò£¬¾­³£Òª·µ»ØÇ°¼¸Ìõ»òÕßÖмäij¼¸ÐÐÊý¾Ý£¬Õâ¸öʱºòÔõô°ìÄØ£¿²»Óõ£ÐÄ£¬mysqlÒѾ­ÎªÎÒÃÇÌṩÁËÕâÑùÒ»¸ö¹¦ÄÜ¡£
SELECT * from table   LIMIT [offset,] rows | rows OFFSET offset
LIMIT ×Ó¾ä¿ÉÒÔ±»ÓÃÓÚÇ¿ÖÆ SELECT Óï¾ä·µ»ØÖ¸¶¨µÄ¼Ç¼Êý¡£LIMIT ½ÓÊÜÒ»¸ö»òÁ½¸öÊý ......

Mysql֪ʶµã×ܽ᣺Flush privileges

mysql> flush privileges;ʲôÒâ˼£¿­
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';­
mysql> flush privileges;­
mysql> quit­
´ð:­
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......

linuxϰ²×°PHP APACHE 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- ......

¹ØÓÚhibernateÅäÖÃc3p0Á¬½Ó³ØÁ¬½ÓmysqlÎÊÌâ

ǰЩÌì¿´ÁËÀî¸Õ<struts2+hibernate+spring>ÄÇÊéÉϵÄhibernate£¬ÅäÖÃÎļþÒ²Êǰ´ÕÕÉÏÃæÇýøhibernate.cfg.xmlÎļþµÄ£¬Student.javaÅäÖõÄStudent.hbm.xmlÎļþ¾õµÃҲûʲôÎÊÌ⣬µ«²»Öªµ½Ôõô»ØÊ¾ÍÊDZ¨ connection can not open¡£ÓôÃÆ°¡£¬ºóÀ´ÎҾͰÑÊéÀïÃæµÄÅäÖÃÎļþºÍÔ´Â룬¸´ÖƵ½MyEclipseÏÂÃæµÄÒ»¸öÐÂwebÏîÄ¿ÖУ¬ÔËÐ ......

MysqlÌáȨ

£¨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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ