MYSQL°²×°Ê§°Ü
ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒµ½ÄǸömysql_serverÎļþ²¢Ë«»÷°²×°µÄʱºò£¬µ¯³öµÄ´íÎóÌáʾ»¹ÊÇÕâÒ»¸ö¡¡¹ÊÔÚ´ËÏò¸ßÊÖÇó¾È
ʲô°æ±¾£¬ÔÚʲôµØ·½ÏÂÔصÄ
Ó¦¸ÃÊÇMySQL´æ·ÅÊý¾ÝµÄµØ·½Ã»ÓÐжµô£¬ÒòΪÄǸöÎļþ¼ÐĬÈϵÄÇé¿öÏÂÊÇÒþ²ØµÄ£¬Äã¿ÉÒÔ°ÑÄǸöÒþ²ØµÄÎļþ¼ÐÕÒ³öÀ´£¬ÏÈжÔØMySQL£¬È»ºóɾ³ýµô´æ·ÅÊý¾ÝµÄÎļþ¼Ð¾Í¿ÉÒÔÕý³£°²×°ÁË¡£ÄǸöÎļþ¼Ðͨ³£ÔÚÕâ¸ö·¾¶Ï£ºC:\Documents and Settings\All Users\Application Data
´ÓÌáʾÉÏ¿´ÊÇij¸öÎļþ²»´æÒýÆðµÄ
Õâ¸ö´íÎóûÔõô¼û¹ý
´ÓÌáʾ¿´£¬Ó¦¸ÃÊÇijÎļþ²»´æÔÚÒýÆðµÄ
½¨ÒéÄãÈ¥¹Ù·½ÏÂÔØÀ´×°ÊÔÊÔ¿´£º
http://dev.mysql.com/downloads/mysql/5.1.html
ÎļþÕÒ²»µ½°¡ ÏÂÔصİ汾ÓÐÎÊÌâ
жÔظɾ»ÁË
·þÎñÎļþ¼Ð ºÍÎļþ¶¼É¾³ý
ÖØа²×°¸ö¹Ù·½µÄ
ÄãÖ±½ÓÏÂÔØÒ»ÏÂZIP°æµÄ£¬Ö±½ÓUNZIPʹÓþÍÐÐÁË¡£
Without installer (unzip in C:\)
http://dev.mysql.com/downloads/mysql/5.1.html#win32
ɾ³ý×¢²á±íÐÅÏ¢,ɾ³ýdataÎļþ¡£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
-> ;
+--------------------------+----------------------------------- ......
select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡
Èç¹ ......
±í½á¹¹
mysqlÊý¾Ý
ÍøÒ³ÏÔʾµÄÊý¾Ý
ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£
ÕâÀïºÍÈÕÎÄÓйØϵ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»
ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......