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_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 ......
1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......
Ò»£ºasp.netÔõôÁ¬½ÓmysqlÊý¾Ý¿â
ÏÂÔØmysql connectionµÄ¶«Î÷
http://dev.mysql.com/downloads/connector/net/6.2.html
ÓÐ3¸ödownloadÑ¡µÚÒ»¸öÏÂÔØ
Windows (x86, 32-bit), ZIP Archive
mysql-connector-net-6.2.2-noinstall.zip ......
1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
if (myform.user.value=="")
{
alert("ÇëÌîдÓû§");
myform.user.focus();
return f ......
MySQLµÄdatetimeÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµ
ÓÉÓÚMySQLĿǰ×ֶεÄĬÈÏÖµ²»Ö§³Öº¯Êý£¬ËùÒÔÓÃ
create_time datetime default now()
µÄÐÎʽÉèÖÃĬÈÏÖµÊDz»¿ÉÄܵġ£
´úÌæµÄ·½°¸ÊÇʹÓÃTIMESTAMPÀàÐÍ´úÌæDATETIMEÀàÐÍ¡£
CURRENT_TIMESTAMP £ºµ±ÎÒ¸üÐÂÕâÌõ¼Ç¼µÄʱºò£¬ÕâÌõ¼Ç¼µÄÕâ¸ö×ֶβ»»á¸Ä±ä
¡£
CURRENT_TIMESTAMP O ......