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Îļþ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë
mysql> select * from userinfo;
+--------+----------+----------+------+-----------+-----------+
| autoid | username | password | sex | realname | q ......
SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369
ÒÔÉ ......
±¾ÈË´¿Êô³õѧMySQL£¬ÏÖÏë°ÑÒ»¸öOracleÉϵĴ洢¹ý³Ì¸Äµ½MySQLÉÏ£¬µ«ÊÇÆäÖÐÓÐÒ»¸ösubstrbµÄ×Ö·û´®°´Î»·µ»ØÖµº¯Êý²»ÖªµÀÓ¦¸ÃÔõô×öÁË£¿Ï£Íû¸÷λǰ±²ÃÇÖ¸µãСµÜÎÒһϣ¬²»Ê¤¸Ð¼¤°¢~~~
Àýaaa := 'dsadsa'; ......