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

MySQL¶¯Ô±14000ÈËÇ©Ãû·´¶Ô¼×¹ÇÎÄSun½»Ò×

¾Ý¹úÍâýÌ屨µÀ£¬MySQLÊý¾Ý¿âµÄ¿ª·¢ÕßMichael WideniusÒÔ¼°²¿·ÖÏà¹ØÈËÊ¿½üÈÕÏòÅ·ÖÞ¡¢ÖйúÓë¶íÂÞ˹µÄ¼à¹Ü»ú¹¹Ìá½»Á˶Լ׹ÇÎÄ-Sun½»Ò׵ķ´¶ÔÒâ¼û£¬ÓдóÔ¼14000ÈËÔÚ¸ÃÒâ¼ûÉÏÇ©×Ö±íʾËûÃǶԴËÊÕ¹ºµÄ·´¶Ô¡£Å·ÃËίԱ»á´ËÇ°Ôø·´¶Ô¼×¹ÇÎÄÊÕ¹ºSun£¬µ«Õâһ¢¶ÏÉó²é»ú¹¹ÔÚ12ÔÂÓֳƣ¬¶Ô´Ë½»Ò×´ï³ÉÒ»¸öÂúÒâµÄ½á¹û±íʾÀÖ¹Û¡£Å·ÃËίԱ»á½«ÔÚ1ÔÂ27 ÈÕ×îÖÕ¾ö¶¨ÊÇ·ñ·ÅÐÐÕâÒ»½»Òס£
WindeniusÔÚÖÜÒ»Ïò¸÷¹ú¼à¹Ü»ú¹¹Ìá½»ÁËÕâ·Ý´øÓÐÇ©ÃûµÄÒâ¼û¡£ÔÚ¼×¹ÇÎĶÔÅ·Ã˱íʾÊÕ¹ºSun²»»áÓ°ÏìÕý³£¾ºÕùºó£¬ÕâÃû¿ª·¢Õß±ãÔÚÍøÕ¾·¢ÆðÁËÒ»Ïî·´¶Ô´Ë½»Ò׵Ļ¡£
·´Â¢¶ÏÂÉÊ¦Ôø±íʾ£¬ÈôÄÜ»ñµÃ´ó¹«Ë¾µÄÖ§³Ö£¬±ã»áÓ°ÏìÒ¡°Ú²»¶¨µÄ¼à¹Ü»ú¹¹×ö³ö¾ö¶¨¡£
MySQLÊÇÊý¾Ý¿âÊг¡µÄºó½øÈëÕߣ¬¸ÃÊг¡ÓÉIT¹«Ë¾¼×¹ÇÎÄ¡¢IBMÓë΢ÈíÕ¼Áì¡£MySQLµÄ½øÈëÀ­µÍÁËÊý¾Ý¿â²úÆ·µÄ¼Û¸ñ£¬Ò²¶¯Ò¡ÁËÕâЩ¾ÞÍ·¹«Ë¾µÄͳÖεØÎ»¡£
WideniusÊÇÓÐÃûµÄ¿ªÔ´Èí¼þ¿ª·¢Õߣ¬ËûÈ¥Äê´ÓSun¹«Ë¾´ÇÖ°£¬´´½¨ÁË×Ô¼ºµÄÊý¾Ý¿â¹«Ë¾Monty Program Ab¡£¶øSun¹«Ë¾ÔÚ2008Äê³â×Ê10ÒÚÃÀÔªÂòÏÂÁËMySQL¡£
WideniusÔÚÌá½»µÄÒâ¼ûÊéÖгƣ¬“Ç©ÃûÕß²»ÏàÐż׹ÇÎÄ»áÉÆ´ýMySQL¡£”Ëû±íʾ½«¼ÌÐø·´¶Ô¸Ã½»Ò×Ö±ÖÁ×îÖÕ½á¹û³ö¯¡£
Ç©Ãû»î¶¯µÄ·¢ÆðÈ˳ƣ¬Óг¬¹ý5000Ãû¸öÈË¿ª·¢ÕßÔÚ·´¶ÔÒâ¼ûÊéÉÏÇ©ÊðÁË×Ô¼ºµÄÃû×Ö£¬»¹ÓÐ3000¸öÇ©ÃûÀ´×ÔÄÇЩʹÓÃMySQLµÄ¹«Ë¾Óë»ú¹¹¹ÍÔ±¡£
ÕâЩǩÃûÔÚ·´¶Ô»î¶¯¿ªÊ¼µÄÒ»ÖÜÄÚÊÕ¼¯Íê³É£¬²¢±»Ìá½»ÖÁÅ·ÃËίԱ»á¡¢Å·ÖÞÒé»á¼°Å·ÃË27¸ö³ÉÔ±¹úµÄ¢¶ÏÉó²é»ú¹¹¡£»î¶¯·¢ÆðÕß»¹ÏòÖйúÉÌÎñ²¿Óë¶íÂÞ˹Áª°î·´Â¢¶Ï´¦Ìá½»ÁËÕâЩǩÃû¡£
24СʱҽÉúÔÚÏß×Éѯ


Ïà¹ØÎĵµ£º

MySQL Ò»´ÎÖ´ÐжàÌõÓï¾äµÄʵÏÖ¼°³£¼ûÎÊÌâ

´úÂëÈçÏÂ:
//Á´½ÓʱÉ趨
mysql_real_connect( ..., CLIENT_MULTI_STATEMENTS );
//»òÕß
//ÖÐ;ָ¶¨
mysql_set_server_option( mysql, MYSQL_OPTION_MULTI_STATEMENTS_ON ); //mysqlÊÇÁ¬½ÓµÄÃû³Æ
µ±Ê¹ÓÃÖ´ÐжàÓï¾ä¹¦Äܺó£¬Ò»¶¨Òª¶ÁÍêÕû¸öresault¼¯£¬·ñÔò»á³öÏÖ´íÎó£ºCommands out of sync; you can't run this co ......

mysql Ë÷Òý

1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
    
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......

mysqlÊý¾Ý¿â·¶Ê½Ïê½â

ÔÚÉè¼Æ¹ØÏµÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØÏµÄ£Ê½RÖеÄÿһ¸ö¾ßÌå¹ØÏµrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......

Windows Ï mysql ±¸·Ý»Ö¸´ÃüÁî


¼ÙÉèmysql °²×°ÔÚc:ÅÌ£¬mysqlÊý¾Ý¿âµÄÓû§ÃûÊÇroot£¬ÃÜÂëÊÇ123456£¬Êý¾Ý¿âÃûÊÇtestdb£¬ÔÚd:Å̸ùĿ¼ÏÂÃæ´æ·Å±¸·ÝÊý¾Ý¿â£¬±¸·ÝÊý¾Ý¿âÃû×ÖΪbackup20070713.sql(20070713.sqlΪ±¸·ÝÈÕÆÚ)
±¸·ÝÊý¾Ý¿â£º
mysqldump -uroot -p123456 testdb>d:/backup20070713.sql
»Ö¸´Êý¾Ý¿â£º
ɾ³ýÔ­ÓÐÊý¾Ý¿â£¬½¨Á¢Êý¾Ý¿â£¬°Ñ±¸·ÝÊý¾Ý ......

Mysql limitÓ÷¨

1.SELECT
 
*
 
from
 
table
 LIMIT
1
,
20
;  
//
 ¼ìË÷¼Ç¼ÐÐ
2-21
   µÚÒ»¸ö²ÎÊý£º²éѯÆðʼÐУ¨´Ó0¿ªÊ¼£©
   µÚ¶þ¸ö²ÎÊý£º²éѯ¼¸Ìõ¼Ç¼
2.
SELECT
 
*
 
from
 
table
 LIMIT
5
,
-
1

//
&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ