Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å8000¶àÌõ¼Ç¼
ÓÃÈçÉÏÓï¾ä²éѯ±È½ÏÂý£¨¿ÉÒÔÃ÷ÏԸоõÓÐÍ£¶Ù£©

Èç¹û¸Ä³ÉÕâÑù£ºselect a.name ,b.name from tableA a,tableB b where b.id = a.id and .....
¼È°ÑµÈÖµ±È½ÏµÄ˳Ðò¸Ä±äһϼ´¿É
ËٶȿÉÒÔ½ÓÊÜ

²»ÖªµÀʲôԭÒò£¬µÈÖµ±È½ÏµÄÔ­ÀíÊÇʲô£¿Çë²»ÁߴͽÌ

Äã·ÖÎöÏÂ2ÖÖÇé¿öϵÄÖ´Ðмƻ®£¬ Ó¦¸Ã¾Í±È½ÏÇå³þÁË£º

SQL code:
explain SQLÓï¾ä


ÓÃmysql¿Í»§¶Ë·ÖÎö¹ýÁË
µÚÒ»ÖÖÇé¿ö ÀïÃæÓÐÒ»¸öÌáʾ£ºRange checked for each record (index map: 0x2)
¶øÁíÍâÒ»¸öÊÇuseing where

Ìù³öexplain SQLÓï¾äÍêÕû½á¹û²ÅÄܱãÓÚ·ÖÎö

Èç¹ûÔÙÓÐshow create table ±íÃû£»show indexes from ±íÃû µÄ½á¹û¾Í¸üºÃ·ÖÎöÁË

explian select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡£

¿´Ò»Ï½á¹ûÊÇʲô£¿

ÀíÂÛÉÏÊDz»»á³öÏÖÄãËù˵µÄÕâÖÖÇé¿öµÄ¡£

µÈÖµ±È½ÏÖ±½ÓËø¶¨Î»ÖÃ

È«±íҪѭ»·ËÑË÷

ÒýÓÃ
µÈÖµ±È½ÏÖ±½ÓËø¶¨Î»ÖÃ

È«±íҪѭ»·ËÑË÷



¹Ø¼üÊǵÈÖµ±È½ÏµÄË«·½¶¼ÊDZäÁ¿ ÊÇÈ«±íËÑËØ»¹ÊÇÖ±½ÓËø¶¨Î»ÖÃ

»¹ÊÇûÓÐÈ˻شð°¡
±ðÈ˶¼Ã»ÓÐÓöµ½Õâ¸öÎÊÌ⣿

ÒýÓ


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

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ÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ