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

MySQLÖеķÖÇø¸ÅÊö

SQL±ê×¼ÔÚÊý¾Ý´æ´¢µÄÎïÀí·½ÃæûÓÐÌṩ̫¶àµÄÖ¸ÄÏ¡£SQLÓïÑÔµÄʹÓöÀÁ¢ÓÚËüËùʹÓõÄÈκÎÊý¾Ý½á¹¹»òͼ±í¡¢±í¡¢ÐлòÁÐϵĽéÖÊ¡£µ«ÊÇ£¬´ó²¿·Ö¸ß¼¶Êý¾Ý¿â¹ÜÀíϵͳÒѾ­¿ª·¢ÁËһЩ¸ù¾ÝÎļþϵͳ¡¢Ó²¼þ»òÕßÕâÁ½ÕßÀ´È·¶¨½«ÒªÓÃÓÚ´æ´¢Ìض¨Êý¾Ý¿éÎïÀíλÖõķ½·¨¡£ÔÚMySQLÖУ¬InnoDB´æ´¢ÒýÇ泤ÆÚÖ§³Ö±í¿Õ¼äµÄ¸ÅÄ²¢ÇÒMySQL·þÎñÆ÷ÉõÖÁÔÚ·ÖÇøÒýÈë֮ǰ£¬¾ÍÄÜÅäÖÃΪ´æ´¢²»Í¬µÄÊý¾Ý¿âʹÓò»Í¬µÄÎïÀí·¾¶¡£
 
·ÖÇøÓÖ°ÑÕâ¸ö¸ÅÄîÍƽøÁËÒ»²½£¬ËüÔÊÐí¸ù¾Ý¿ÉÒÔÉèÖÃΪÈÎÒâ´óСµÄ¹æÔò£¬¿çÎļþϵͳ·ÖÅäµ¥¸ö±íµÄ¶à¸ö²¿·Ö¡£Êµ¼ÊÉÏ£¬±íµÄ²»Í¬²¿·ÖÔÚ²»Í¬µÄλÖñ»´æ´¢Îªµ¥¶ÀµÄ±í¡£Óû§ËùÑ¡ÔñµÄ¡¢ÊµÏÖÊý¾Ý·Ö¸îµÄ¹æÔò±»³ÆΪ·ÖÇøº¯Êý£¬ÕâÔÚMySQLÖÐËü¿ÉÒÔÊÇÄ£Êý£¬»òÕßÊǼòµ¥µÄÆ¥ÅäÒ»¸öÁ¬ÐøµÄÊýÖµÇø¼ä»òÊýÖµÁÐ±í£¬»òÕßÊÇÒ»¸öÄÚ²¿HASHº¯Êý£¬»òÒ»¸öÏßÐÔHASHº¯Êý¡£º¯Êý¸ù¾ÝÓû§Ö¸¶¨µÄ·ÖÇøÀàÐÍÀ´Ñ¡Ôñ£¬°ÑÓû§ÌṩµÄ±í´ïʽµÄÖµ×÷Ϊ²ÎÊý¡£¸Ã±í´ïʽ¿ÉÒÔÊÇÒ»¸öÕûÊýÁÐÖµ£¬»òÒ»¸ö×÷ÓÃÔÚÒ»¸ö»ò¶à¸öÁÐÖµÉϲ¢·µ»ØÒ»¸öÕûÊýµÄº¯Êý¡£Õâ¸ö±í´ïʽµÄÖµ´«µÝ¸ø·ÖÇøº¯Êý£¬·ÖÇøº¯Êý·µ»ØÒ»¸ö±íʾÄǸöÌض¨¼Ç¼Ӧ¸Ã±£´æÔÚÄĸö·ÖÇøµÄÐòºÅ¡£Õâ¸öº¯Êý²»ÄÜÊdz£Êý£¬Ò²²»ÄÜÊÇÈÎÒâÊý¡£Ëü²»ÄÜ°üº¬Èκβéѯ£¬µ«ÊÇʵ¼ÊÉÏ¿ÉÒÔʹÓÃMySQL ÖÐÈκοÉÓõÄSQL±í´ïʽ£¬Ö»Òª¸Ã±í´ïʽ·µ»ØÒ»¸öСÓÚMAXVALUE£¨×î´ó¿ÉÄܵÄÕýÕûÊý£©µÄÕýÊýÖµ¡£
µ±¶þ½øÖÆÂë±ä³É¿ÉÓÃʱ£¨Ò²¾ÍÊÇ˵£¬5.1 -max ¶þ½øÖÆÂ뽫ͨ¹ý--with-partition ½¨Á¢£©£¬·ÖÇøÖ§³Ö¾Í½«°üº¬ÔÚMySQL 5.1µÄ-max °æ±¾ÖС£Èç¹ûMySQL¶þ½øÖÆÂëÊÇʹÓ÷ÖÇøÖ§³Ö½¨Á¢µÄ£¬ÄÇô¼¤»îËü²»ÐèÒªÈκÎÆäËûµÄ¶«Î÷ (ÀýÈ磬ÔÚmy.cnf ÎļþÖУ¬²»ÐèÒªÌØÊâµÄÌõÄ¿)¡£¿ÉÒÔͨ¹ýʹÓÃSHOW VARIABLESÃüÁîÀ´È·¶¨MySQLÊÇ·ñÖ§³Ö·ÖÇø£¬ÀýÈ磺
 
mysql> SHOW VARIABLES LIKE '%partition%';
 
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| have_partition_engine | YES   |
+-----------------------+-------+
1 row in set (0.00 sec)
ÔÚÈçÉÏÁгöµÄÒ»¸öÕýÈ·µÄSHOW VARIABLES ÃüÁîËù²úÉúµÄÊä³öÖУ¬Èç¹ûûÓп´µ½±äÁ¿have_partition_engineµÄֵΪYES£¬ÄÇôMySQLµÄ°æ±¾¾Í²»Ö§³Ö·ÖÇø¡££¨×¢Ò⣺ÔÚÏÔʾÈκÎÓйطÖÇøÖ§³ÖÐÅÏ¢µÄÃüÁîSHOW ENGINESµÄÊä³öÖУ¬²»»á¸ø³öÈκÎÐÅÏ¢£»±ØÐëʹÓÃSHOW VARIABLESÃüÁîÀ´×ö³öÕâ¸öÅжϣ©¡£
 
¶ÔÓÚ´´½¨ÁË·ÖÇøµÄ±í£¬¿ÉÒÔʹÓÃÄãµÄMySQL ·þÎñÆ


Ïà¹ØÎĵµ£º

ʹÓà MySQL Workbench ¿ÉÊÓ»¯µÄÉè¼Æ MySQL Êý¾Ý¿â

MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³Æ֮ΪÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌض¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌع淶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁË°üº¬± ......

Mysql ʱ¼äº¯Êý»ã×Ü

 Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µÄÈÕÆÚʱ¼äÍ⣬MySQL Öл¹ÓÐÏÂÃæµÄº¯Êý£º
current_tim ......

MysqlÓÅ»¯·½°¸Ö®Ë÷ÒýµÄʹÓÃ

 
Ë÷ÒýÓÃÓÚ¿ìËÙÕÒ³öÔÚij¸öÁÐÖÐÓÐÒ»Ìض¨ÖµµÄÐС£²»Ê¹ÓÃË÷Òý£¬MySQL±ØÐë´ÓµÚ1Ìõ¼Ç¼¿ªÊ¼È»ºó¶ÁÍêÕû¸ö±íÖ±µ½ÕÒ³öÏà¹ØµÄÐС£±íÔ½´ó£¬»¨·ÑµÄʱ¼äÔ½¶à¡£Èç¹û±íÖвéѯµÄÁÐÓÐÒ»¸öË÷Òý£¬MySQLÄÜ¿ìËÙµ½´ïÒ»¸öλÖÃÈ¥ËÑÑ°µ½Êý¾ÝÎļþµÄÖм䣬ûÓбØÒª¿´ËùÓÐÊý¾Ý¡£Èç¹ûÒ»¸ö±íÓÐ1000ÐУ¬Õâ±È˳Ðò¶ÁÈ¡ÖÁÉÙ¿ì100±¶¡£×¢ÒâÈç¹ûÄãÐèÒª·ÃÎÊ ......

MySqlÖд´½¨ÊÓͼ

 
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£s ......

mysql²Ù×÷ Left join , Right Join, Inner Join


Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid   adate
1      a1
2      a2
3      a3
TableB
bid bdate
1    b1
2   b2
4    b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ