Çë½ÌmysqlÊý¾Ý¿â»¹ÔµÄÎÊÌâ
Ö®Ç°Ð¶ÔØÁËmysql£¬ÖØÐ°²×°ÁËÏ£¬È»ºó֮ǰ°æ±¾µÄmysqlϵÄdataĿ¼ÖÐÊý¾Ý¿âÎļþ¸ñʽΪ£º.MYD ¡¢.MYIÖ®ÀàµÄ¶«Î÷
µ½°Ù¶ÈËÑÁËÏ£¬Ëµ°ÑÕâЩ¿½±´µ½ÐµÄmysql°²×°Ä¿Â¼ÏµÄdataĿ¼Öм´¿Éʶ±ð£¬µ«ÊǺÃÏñ»¹ÊÇʶ±ð²»Á˰¡£¿Ó¦¸ÃÔõô»¹ÔÕâЩ¸ñʽµÄÊý¾Ý¿âÄØ£¿
µ«ÊǺÃÏñ»¹ÊÇʶ±ð²»Á˰¡£º
Ìáʾʲô´íÎóÐÅÏ¢
ºÃÏñҲûɶ´íÎóÌáʾ£¬¾ÍÊÇÓÃphpmyadmin¿´²»µ½Êý¾Ý¿â¡£¡£
È»ºó³ÌÐòÎÞ·¨Á¬½ÓÊý¾Ý¿â
Ä㽨Á¢Êý¾Ý¿âûÓУ¿ÓÐÎÞÏàӦĿ¼£¿
Óеģ¬ÎÒÔÚɾ³ý֮ǰ£¬Êý¾Ý¿âÊÇÔÚD:\mysql\data\webdataĿ¼ÏÂ
ɾ³ýÖØÐ°²×°ºó£¬½«Ö®Ç°±¸·ÝµÄwebdataÄ¿Â¼ÖØÐ¿¼µ½Ðµİ²×°Ä¿Â¼µÄdataÏÂÃæÁË£¬µ«ÊÇÒÀ¾ÉÎÞ·¨Ê¶±ð¡£
Õâ¸öºÍ±àÂëÓйØÏµÂð?ÎÒÏÖÔÚÓõÄÊÇutf-8±àÂ룬֮ǰÓõÄʲô±àÂëÍü¼ÇÁË
Ä㽨Á¢webdataÊý¾Ý¿â£¿
show tables; ¿´Ò»ÏÂÕâЩ±íÔÚ²»ÔÚ£¿
Èç¹ûÔÚ£¬Ôò˵Ã÷±íÎļþ *.frm, *.myd, *.myi ÖÁÉÙλÖÃÕýÈ·ÁË¡£È»ºóÔÙ¿´
webdataÊý¾Ý¿âÊÇÒÔÎļþ¼ÐµÄÐÎʽ´æÔÚÔÚdataĿ¼Ïµģ¬ÕâÀïÃæÓкܶàMYIÖ®ÀàÀ©Õ¹ÃûµÄÊý¾Ý¿âÎļþ£¬ÏÖÔÚµÄÎÊÌâ¾ÍÊDz»ÖªµÀÔõô»¹Ôµ½Ð°²×°µÄÊý¾Ý¿âÖУ¬Ôε¹
ÊÇÔÚmysqlÃüÁîÐÐÏÂÊäÂð£¿ÌáʾNO database selected
datadir¡¡ÖеÄÖµÊÇʲô£¿
È«ÊÇ*.MYI¡¢*.MYD¡¢*.frmÎļþ
ÖÕÓÚÕÒµ½ÔÒòÁË
5.1ºóа汾£¬Êý¾Ý¿â²»ÊÇÔÚ°²×°Ä¿Â¼ÏÂÃæ£¬¶øÊÇÔÚC:\Documents and Set
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......