Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄ×Ô¶¯¶Ï¿ªÁ¬½ÓÎÊÌâ

 MySQL »á×Ô¶¯¶Ï¿ª IDLE ʱ¼ä³¬¹ý 8 СʱµÄÊý¾Ý¿âÁ¬½Ó£¬´Ó¶øµ¼ÖÂһЩ»ùÓÚÊý¾Ý¿âÁ¬½ÓµÄÓ¦ÓóÌÐò£¬ÌرðÊÇ WEB Ó¦ÓóÌÐò³ö´í¡£
ÓÐÁ½¸ö°ì·¨¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣺
µÚÒ»¸ö°ì·¨ÊÇÐÞ¸Ä MySQL µÄÅäÖòÎÊý¡£Õâ¸ö²ÎÊýµÄÃû³ÆÊÇ wait_timeout
£¬ÆäĬÈÏֵΪ 28800(µ¥Î»Ãë)£¬¸ÕºÃ¾ÍÊÇ 8 Сʱ¡£ÆäÒâÒåΪ¹Ø±ÕÒ»¸öÁ¬½Ó֮ǰÔÚÕâ¸öÁ¬½ÓÉϵ ......

mysql µÄһЩ³£ÓÃÃüÁî

 ÔÊÐíËùÓÐÖ÷»úÔ¶³Ì·ÃÎÊ
GRANT ALL PRIVILEGES ON *.* TO 'dba'@'%' IDENTIFIED BY 'dbapassword' WITH GRANT OPTION;
Ö¸¶¨Ö÷»ú¿ÉÔ¶³Ì
GRANT ALL PRIVILEGES ON *.* TO 'dba'@'192.168.0.100' IDENTIFIED BY 'dbapassword' WITH GRANT OPTION;
Ö¸¶¨È¨ÏÞ¿ªÔ¶³Ì
grant select,insert,update,delete on test.* to db ......

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ºÍOracleµÄһЩ²Ù×÷Çø±ð

 ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......

MySQL Êý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´

 
mysql,mysqldump,µ¼³ö,µ¼³ö±í,ѹËõµ¼³ömysql,mysqlhotcopy,mysql»¹Ô­±í
±¾ÎÄÌÖÂÛ MySQL µÄ±¸·ÝºÍ»Ö¸´»úÖÆ£¬ÒÔ¼°ÈçºÎά»¤Êý¾Ý±í£¬°üÀ¨×îÖ÷ÒªµÄÁ½ÖÖ±íÀàÐÍ£ºMyISAM
ºÍ Innodb
£¬ÎÄÖÐÉè¼ÆµÄ MySQL °æ±¾Îª 5.0.22¡£
Ŀǰ MySQL Ö§³ÖµÄÃâ·Ñ±¸·Ý¹¤¾ßÓУºmysqldump¡¢mysqlhotcopy
£¬»¹¿ÉÒÔÓà SQL Óï·¨½øÐб¸·Ý£ºBACK ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ