Ò»¸ö¼òµ¥µÄ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ÄÚÖÃÈ«ÎļìË÷ʵÏÖÖÐÎĵÄÏà¹Ø¼ìË÷
¹Ø¼ü×Ö£ºMySQL È«ÎļìË÷ È«ÎÄË÷Òý ÖÐÎÄ·Ö´Ê ¶þÔª·Ö´Ê ÇøÎ»Âë ÏàËÆ¶È
×¢£º±¾ÎÄʹÓõÄMySQL°æ±¾Îª£ºMySQL 4.0.x
ÔÚMySQL4ÖУ¬ÊÇÒѾ¿ªÊ¼Ö§³ÖÈ«ÎļìË÷£¨Ë÷Òý£©µÄÁË¡£µ«ÊÇÖ»ÊǶÔÓ¢ÎÄÖ§³ÖÈ«ÎļìË÷¡£
ÓÉÓÚÓ¢ÎÄÔÚÊéдÉϵÄÌØÊâÐÔ£¬Ê¹µÃ·Ö´ÊËã·¨Ïà¶ÔÖÐÎÄÀ´Ëµ£¬¼òµ¥µÃ¶à¡£Ò»°ãÀ´Ëµ£¬ÎÒÃÇ ......
֮ǰ£¬ÓÉÓÚ¿Í»§ÒªÇóÔÚcentOSϰ²×°ÏµÍ³Ó¦Óã¬Òò´ËÓлú»á½Ó´¥ÁËÒ»ÏÂCentOS£¬Ë³±ãÒ²Á˽âÁËÏÂCentOSµÄ³£¹æ²Ù×÷£¬»¹ÓÐÔÚCentOSϵÄMySQLÏà¹Ø²Ù×÷¡£
Ŀǰ¼¼Êõ¿ò¼ÜʹÓÃJSF£¨richfaces¡¢facelets£©+Spring+JPA£¨OpenJPA£©£¬²»Ê¹ÓÃÊý¾Ý¿âÒÀÀµµÄ´¥·¢Æ÷»ò´æ´¢¹ý³Ì£¬ËùÓÐÒµÎñÂß¼ÔÚweb·þÎñÆ÷ÉÏÖ´ÐУ¬Òò´ËÊý¾Ý¿â»ù±¾²»Óÿ¼ÂÇÒÆ ......
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 | ......
PS:ÎÒ½ñÌìÅäÖà ·þÎñÆ÷µÄʱºò³öÏÖµÄÎÊÌâ¾ÍÊÇÕâ¸ö£¬µ«ÊÇÕÕ×Å·½·¨¶¼×öÁË£¬Ñ¾µÄ¡£¡£»¹ÊÇûÓ㬼«¶ÈÓôÃÆËÀ¡£¡£°¥¡£¡£¡£ÎÒÒ²²»ÖªµÀʲôÔÒòÄØ¡£¡£¿ÉÄܵÄÔÒò¶¼ÕÒ¹ýÁË¡£¡£ÓôÃÆ°¡`~
apache2+mysql+php5+phpmyadminÅäÖÃÎÊÌ⣺ÎÞ·¨¼ÓÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÃ...
°²×°Íêapache2+mysql+php5ºó£¬°²×°phpmyadmin²¢ÅäÖúÃÒÔºó£¬ÔÚä¯À ......
mysql,mysqldump,µ¼³ö,µ¼³ö±í,ѹËõµ¼³ömysql,mysqlhotcopy,mysql»¹Ô±í
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM
ºÍ Innodb
£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy
£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACK ......