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Îļþ¡£
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡
Èç¹ ......
±í½á¹¹
mysqlÊý¾Ý
ÍøÒ³ÏÔʾµÄÊý¾Ý
ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£
ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»
ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......