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 ·þÎñÆ
Ïà¹ØÎĵµ£º
×Ô¼º½â¾ö°ì·¨£ºÔÚmy.iniÖн«Á½´¦latin1¸Ä³Éutf8¼´¿É
Ò»¡¢ÂÒÂë²úÉúÔÒò
MySQL ×Ö·û±àÂëÊÇ°æ±¾4.1ÒýÈëµÄ£¬Ö§³Ö¶à¹úÓïÑÔ£¬¶øÇÒһЩÌØÐÔÒѾ³¬¹ýÁËÆäËü´ó¶àÊýÊý¾Ý¿â¹ÜÀíϵͳ¡£ÕýÒòΪÕâÒ»ÌØÐԲŵ¼Ö MySQL µÄÂÒÂëÎÊÌâ¡£
×Ö·û¼¯ÊÇÒ»Ì×·ûºÅºÍ±àÂ롣У¶Ô¹æÔòÊÇÔÚ×Ö·û¼¯ÄÚÓÃÓڱȽÏ×Ö·ûµÄÒ»Ì×¹æÔò¡£ÈÃÎÒÃÇʹÓÃÒ»¸ö¼ÙÏë×Ö·û ......
ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
Ç°Ì᣺
1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏÈ°Ñpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pi ......
MySQL·þÎñÆ÷°üº¬Ò»Ð©ÆäËûSQL DBMSÖв»¾ß±¸µÄÀ©Õ¹¡£×¢Ò⣬Èç¹ûʹÓÃÁËËüÃÇ£¬½«ÎÞ·¨°Ñ´úÂëÒÆÖ²µ½ÆäËûSQL·þÎñÆ÷¡£ÔÚijЩÇé¿öÏ£¬Äã¿ÉÒÔ±àд°üº¬MySQLÀ©Õ¹µÄ´úÂ룬µ«ÈÔ±£³ÖÆä¿ÉÒÆÖ²ÐÔ£¬·½·¨ÊÇÓÓ/*... */”×¢Ê͵ôÕâЩÀ©Õ¹¡£MySQL·þÎñÆ÷Äܹ»½âÎö²¢Ö´ÐÐ×¢ÊÍÖеĴúÂ룬¾ÍÏñ¶Ô´ýÆäËûMySQLÓï¾äÒ»Ñù£¬µ«ÆäËûSQL·þÎñÆ÷½«ºöÂÔ ......
mysql°²×°Í¼½â½Ì³Ì 5.1
2009Äê03ÔÂ01ÈÕ ÐÇÆÚÈÕ 23:51
תÔØÇë×¢Ã÷³ö´¦:http://hi.baidu.com/herdff/blog/item/6e6b4bcf6132f90b93457e14.html
±¾½Ì³ÌÒÔMysql 5.1°æ±¾ÎªÀý£¬¸ü¸ß°æ±¾°²×°¹ý³ÌÓë´ËÀàËÆ¡£ÔĶÁÇ°£¬ÇëÏÂÔØ5.1£¬ÏÂÔصØÖ·£ºwww.mysql.com
°²×°¹ý³ÌÓëÆäËüWindows°²×°³ÌÐòÒ»Ñù£¬Ê×ÏȳöÏÖµÄÊÇ°²×°Ïòµ¼»¶Ó½çÃæ
Ö ......