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

MySQLÁÙʱ±í½¨Á¢

MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GROUP BY article;
--²éѯÁÙʱ±íÊý¾Ý
SELECT article, dealer, price from shop, tmpWHERE shop.article=tmp.articel AND shop.price=tmp.price;
--UNLOCK TABLES;
DROP TABLE tmp;


Ïà¹ØÎĵµ£º

Mysql´æ´¢¹ý³Ì£¨Î壩——SEQUENCEµÄʵÏÖ

ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......

mysql unionÓï·¨

Ò» UNIONÓï·¨
´úÂë ¸´ÖÆ´úÂë
SELECT ...   
UNION [ALL | DISTINCT]   
SELECT ...   
[UNION [ALL | DISTINCT]   
SELECT ...]  
SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT] SELECT ...]
UNIONÓÃÓÚ°Ñ ......

mysqlÐÔÄÜÖ¸±ê

mysqladmin extended (¾ø¶ÔÖµ)
ÖØµãÈ¥¼àÊÓµÄÖµÓУº
* Slave_running:Èç¹ûϵͳÓÐÒ»¸ö´Ó¸´ÖÆ·þÎñÆ÷£¬Õâ¸öÖµÖ¸Ã÷ÁË´Ó·þÎñÆ÷µÄ½¡¿µ¶È
* Threads_connected:µ±Ç°¿Í»§¶ËÒÑÁ¬½ÓµÄÊýÁ¿¡£Õâ¸öÖµ»áÉÙÓÚÔ¤ÉèµÄÖµ£¬µ«ÄãÒ²ÄܼàÊÓµ½Õâ¸öÖµ½Ï´ó£¬Õâ¿É±£Ö¤¿Í»§¶ËÊÇ´¦ÔÚ»îԾ״̬¡£
* Threads_running:Èç¹ûÊý¾Ý¿â³¬¸ººÉÁË£¬Ä㽫»áµÃµ½Ò»¸ö ......

EMS SQL Manager for Mysql°ïÁËÎ񵀾£¬²¿·ÖÁеIJÙ×÷

 
ÓÉÓÚµ±³õ±íÉè¼ÆµÄ²»ºÏÀí£¬ÂýÂýµÄ·¢ÏÖÀË·ÑÐí¶à¿Õ¼ä£¬ÇÒ¶ÔÀ©Õ¹²»Àû¡£¾ö¶¨²»°ÑͬÀàÐÍÄÚÈݲ¢ÅÅÁб£´æ£¬ËùÒÔ½ñÌì°Ñ¶àÓàµÄÁмôµô£¬²¹ÔÚ±£ÁôµÄÁÐÏÂÃæ¡£
 
 
 
ÔÚ±íÃûµãÓÒ¼ü£¬Êý¾Ý²Ù×÷£¬µ¼³öSQL½Å±¾Êý¾Ý¡£ÕÕÌáʾ²Ù×÷£¬ÕâÀïÎÒϲ»¶µÄÊÇ¿ÉÒÔÖ¸¶¨Áе¼³ö¡£
 
È»ºó°Ñ²»ÐèÒªµÄ¿ÕÁÐɾµô£¬¸ÄһϲåÈëµÄÁÐ ......

MySQL ShowÃüÁîµÄʹÓÃ

show tables»òshow tables from database_name;
½âÊÍ£ºÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
show databases;
½âÊÍ£ºÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
show processlist;
½âÊÍ£ºÏÔʾϵͳÖÐÕýÔÚÔËÐеÄËùÓнø³Ì£¬Ò²¾ÍÊǵ±Ç°ÕýÔÚÖ´ÐеIJéѯ¡£´ó¶àÊýÓû§¿ÉÒԲ鿴
ËûÃÇ×Ô¼ºµÄ½ø³Ì£¬µ«ÊÇÈç¹ûËûÃÇÓµÓÐprocessȨÏÞ£¬¾Í¿ÉÒԲ鿴ËùÓÐÈ˵Ľø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ