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

Ò»¸ö¼òµ¥µÄMysqlµÄÁªºÏ²éѯÁÐ×Ó

 
Ò»¸ömysqlµÄÁªºÏ²éѯÁÐ×Ó£¬ºÜ»ù±¾µÄ£¬²»¹ýºÜʵÓá£
ÏÈ¿´Êý¾Ý±í¡£Êý¾Ý±íclass£º
------------------------------- 
id   cname
-------------------------------
1    ÄÐ×°
2    ŮƤ¿ã
3    Å®²ÊÃÞ
-------------------------------
class±í´æ·ÅµÄÊDzúÆ·µÄ´óÀàÃû³ÆºÍÆäÐòºÅ
Êý¾Ý±íproduct£º
-------------------------------
pid   ptype   pparent
-------------------------------
1      A01      1
2      A21      1
3      B10      2
4      C11      3
5      C01      2
-------------------------------
product±í´æ·ÅµÄÊDzúÆ·Ãû³Æ£¬ºÍÆäËùÊô´óÀàµÄid£¨pparent£© 
ÏÖÔÚÒªÇóÏÔʾËùÓвúÆ·ÐòºÅ¡¢Ãû³Æ¡¢ËùÊôÀà±ð£¬ÈçÏÂÐÎʽ£º
-------------------------------
ÐòºÅ Ãû³Æ     Àà±ð
-------------------------------
1      A01      ÄÐ×°
2      A21      ÄÐ×°
3      B10      ŮƤ¿ã
4      C11      Å®²ÊÃÞ
5      C01      ŮƤ¿ã
-------------------------------
ÕâÀïÒª²éѯproduct±í£¬¸ù¾Ýpparent×Ö¶ÎÔÙ¶Á³ö¶ÔÓ¦µÄclass±íÖÐpname×ֶΡ£×ͳµÄ£¬¿ÉÒÔÓÃÁ½¸öselectÓï¾äʵÏÖ£¬µ«ÊÇmysqlÖÐÓÐÁªºÏ²éѯÓï¾ä¿ÉÒÔ¼òµ¥µÄʵÏÖ£º
select product.*, class.* from product inner join class on product.pparent=class.id where product.pid is not null
ÔÚphpÖУ¬Í¨¹ýÕâÑù²éѯ³öÀ´µÄ¼Ç¼¶¼·ÅÔÚÊý×éÀïÃæ£¬±ÈÈ磺
$myrow=mysql_fetch_array(mysql_query($sql));
ÄÇô$myrowÊý×éÖУ¬Ç°Ãæ´æ·ÅµÄÊÇproductÖеÄ×ֶΣ¬ºóÃæ´æ·ÅµÄÊÇclassµÄ×ֶΡ£


Ïà¹ØÎĵµ£º

mysqlÊý¾Ý¿â±àÂë

1.È¥MysqlµÄ°²×°Ä¿Â¼Ï嵀 binĿ¼Ï ÔËÐÐ MySQLInstanceConfig.exe
  ÔÚÓïÑÔÉèÖõÄÒ³ÃæÓÐÈý¸öÑ¡Ïî: standard character set
                              best support for multilingualism
          ......

¡¾×ª¡¿ÔÚWindowsÉÏÅäÖò¢ÕûºÏPHPºÍMySQL¾­µä½Ì³Ì

ÔÚΪÓû§Ìṩ¶¯Ì¬ÄÚÈÝ·½Ã棬PHPºÍMySQLÊÇÒ»¸öÇ¿´óµÄ×éºÏ¡£ÕâЩÄêÀ´£¬ÕâÁ½Ïî²úÆ·ÒѾ­¿çÔ½ÁËËüÃÇ×î³õµÄÓ¦ÓÃÎę̀£¬ÏÖÔÚ£¬Ò»Ð©ÊÀ½çÉÏ×æµÄÍøÕ¾Ò²ÔÚÓ¦ÓÃËüÃÇ¡£ËäÈ»ËüÃǵ±³õ¶¼ÊÇ¿ªÔ´Èí¼þ£¬Ö»ÄÜÔÚUNIX/LinuxÉÏÔËÐУ¬µ«¾­¹ýÏ൱һ¶ÎʱÆÚµÄ·¢Õ¹£¬ËüÃÇÒÑÄÜÔÚWindowsƽ̨ÉÏÔËÐС£
ÔÚ±¾ÎÄÖУ¬ÎÒ½«Öð²½ÎªÄãÃÇ˵Ã÷ÈçºÎÔÚWindows»·¾³ÖÐ ......

MySQL²éѯÓÅ»¯¼¼ÊõϵÁн²×ù֮ʹÓÃË÷Òý£¨¶þ£©

 Ë÷ÒýµÄ´ú¼Û
¡¡¡¡Ò»°ãÀ´Ëµ£¬Èç¹ûMySQLÄܹ»ÕÒµ½·½·¨£¬ÀûÓÃË÷ÒýÀ´¸ü¿ìµØ´¦Àí²éѯ£¬Ëü¾Í»áÕâÑù×ö¡£Õâ
Òâζ×Å£¬¶ÔÓÚ´ó¶àÊýÇé¿ö£¬Èç¹ûÄãûÓÐ¶Ô±í½øÐÐË÷Òý£¬¾Í»áʹÐÔÄÜÊܵ½Ë𺦡£Õâ¾ÍÊÇÎÒËùÃè»æµÄË÷ÒýÓŵãµÄÃÀ¾°¡£µ«ÊÇËüÓÐȱµãÂð£¿Óеģ¬ËüÔÚʱ¼äºÍ¿Õ¼äÉ϶¼Óпª
Ïú¡£ÔÚʵ¼ùÖУ¬Ë÷ÒýµÄÓŵãµÄ¼ÛÖµÒ»°ã»á³¬¹ýÕâЩȱµã£¬µ«ÊÇÄ ......

MYSQl left joinÁªºÏ²éѯЧÂÊ·ÖÎö

user±í:
id | name
———
1 | libk
2 | zyfon
3 | daodao
user_action±í:
user_id | action
—————
1 | jump
1 | kick
1 | jump
2 | run
4 | swim
sql:
select id, name, action from user as u
left join user_action a on u.id = a.user_id
result:
id | ......

ÎÞ·¨ÔØÈë mysql À©Õ¹£¬Çë¼ì²é PHP ÅäÖá­¡­½â¾ö°ì·¨

PS:ÎÒ½ñÌìÅäÖà ·þÎñÆ÷µÄʱºò³öÏÖµÄÎÊÌâ¾ÍÊÇÕâ¸ö£¬µ«ÊÇÕÕ×Å·½·¨¶¼×öÁË£¬Ñ¾µÄ¡£¡£»¹ÊÇûÓ㬼«¶ÈÓôÃÆËÀ¡£¡£°¥¡£¡£¡£ÎÒÒ²²»ÖªµÀʲôԭÒòÄØ¡£¡£¿ÉÄܵÄÔ­Òò¶¼ÕÒ¹ýÁË¡£¡£ÓôÃÆ°¡`~
apache2+mysql+php5+phpmyadminÅäÖÃÎÊÌ⣺ÎÞ·¨¼ÓÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÃ...
°²×°Íêapache2+mysql+php5ºó£¬°²×°phpmyadmin²¢ÅäÖúÃÒÔºó£¬ÔÚä¯À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ