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 ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......
À´Ô´£ºhttp://www.blogjava.net/Alpha/archive/2007/07/23/131912.html
//Ö÷¼ü549830479
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ549830479
alter table t2 add d timestamp;
alter table infos add ......
¹Ø¼ü×Ö: mysql6 mysql6ÏÂÔØ
×÷ΪһÃû¿ª·¢ÈËÔ±,ÎÒ¶ÔÂÌɫСÈí¼þÇéÓжÀÖÓ,ÒòΪÓÃÆðÀ´·½±ã¿ì½ÝÂï,±ãÓÚЯ´ø,Ò×ÓÚÔÚÑÝʾϵͳÖÐʹÓÃ,¿ª·¢Ê±¿ÉÁ¢¼´½øÈë״̬. £¨ÔÚ¸½¼þÖУ©
ÒÔÏÂÊÇÏêϸ˵Ã÷:
MySQL 6 ÂÌÉ«¾«¼ò°æ(BAT°æ±¾)
MySQL 6 Ö§³ÖÍâ¼ü,ÊÓͼ´æ´¢¹ý³Ì,ÊÂÎñµÈ¹¦ÄÜ(ÂÌÉ«¾« ......
Ò».ÏÈ¿´Ò»Ð©×î¼òµ¥µÄÀý×Ó
Àý×Ó
Table A
aid adate
1 a1
2 a2
3 a3
TableB
bid bdate
1 b1
2 b2
4 b4
Á½¸ö±ía,bÏàÁ¬½Ó,Ҫȡ ......
ÍêÕûµÄʵÏÖÁËPHP½«Í¼Æ¬´æÈëMYSQL
Ç°Ì᣺
1 Ê×ÏȱØÐëÓµÓÐPHPµÄÔËÐл·¾³£¬ÁíÍ⻹µÃÓÐMYSQLÊý¾Ý¿â
2 Èç¹ûÎļþ²»ÄÜÉÏ´«³É¹¦Çë¼ì²épicsÊÇ·ñÊÇ¿ÉдµÄȨÏÞ
Ê×ÏÈÏÈ°Ñpic2db.rarÎļþ½âѹµ½PHP¿ÉÒÔÔËÐÐĿ¼Ï¡£
Æä´ÎÔÚMYSQLÖн¨Á¢Ò»¸öÊý¾Ý¿â:pic2db,È»ºóÔÚ¸ÃÊý¾Ý¿âϽ¨Á¢Ò»¸ö±í£¬±í½á¹¹Îª£º
CREATE TABLE `pi ......