mysql ½¨Á¢Ë÷Òý
¾ÍÏóÐí¶àµÄPHP¿ª·¢ÕßÒ»Ñù£¬ÔÚ¸Õ¿ªÊ¼½¨Á¢¶¯Ì¬ÍøÕ¾µÄʱºò£¬ÎÒ¶¼ÊÇʹÓÃÏà¶Ô¼òµ¥
µÄÊý¾Ý½á¹¹¡£PHPÔÚÁ¬½ÓÊý¾Ý¿â·½ÃæµÄȷʵÊÇÊ®·Ö·½±ã£¨ÒëÕß×¢£ºÓÐЩÈËÈÏΪPHPÔÚÁ¬½Ó²»Í¬Êý¾Ý¿âʱûÓÐÒ»¸öͳһµÄ½Ó¿Ú£¬²»Ì«·½±ã£¬ÆäʵÕâ¿ÉÒÔͨ¹ýһЩÀ©
Õ¹¿âÀ´×öµ½ÕâÒ»µã£©£¬ÄãÎÞÐè¿´´óÁ¿µÄÉè¼ÆÎĵµ¾Í¿ÉÒÔ½¨Á¢ºÍʹÓÃÊý¾Ý¿â£¬ÕâÒ²ÊÇPHP»ñµÃ³É¹¦µÄÖ÷ÒªÔÒòÖ®Ò»¡£
ǰЩʱºò£¬Ò»Î»ÆÄ¸ß¼¶
µÄ³ÌÐòÔ±¾ÓÈ»ÎÊÎÒʲô½Ð×öË÷Òý£¬ÁîÎҸе½Ê®·ÖµÄ¾ªÆæ£¬ÎÒÏëÕâ¾ø²»»áÊDz׺£Ò»ËÚ£¬ÒòΪÓгÉǧÉÏÍòµÄ¿ª·¢Õߣ¨¿ÉÄܴ󲿷ÖÊÇʹÓÃMySQLµÄ£©¶¼Ã»ÓÐÊܹýÓйØÊý
¾Ý¿âµÄÕý¹æÅàѵ£¬¾¡¹ÜËûÃǶ¼Îª¿Í»§×ö¹ýһЩ¿ª·¢£¬µ«È´¶ÔÈçºÎΪÊý¾Ý¿â½¨Á¢Êʵ±µÄË÷ÒýËùÖª½ÏÉÙ£¬Òò´ËÎÒÆðÁËдһƪÏà¹ØÎÄÕµÄÄîÍ·¡£
×îÆÕͨµÄÇé¿ö£¬ÊÇΪ³öÏÖÔÚwhere×Ó¾äµÄ×ֶν¨Ò»¸öË÷Òý¡£Îª·½±ã½²Êö£¬ÎÒÃÇÏȽ¨Á¢Ò»¸öÈçÏÂµÄ±í¡£
Code´úÂëÈçÏÂ:
CREATE TABLE mytable (
¡¡id serial primary key,
¡¡category_id int not null default 0,
¡¡user_id int not null default 0,
¡¡adddate int not null default 0
);
ºÜ¼òµ¥°É£¬²»¹ý¶ÔÓÚҪ˵Ã÷Õâ¸öÎÊÌ⣬ÒѾ×ã¹»ÁË¡£Èç¹ûÄãÔÚ²éѯʱ³£ÓÃÀàËÆÒÔϵÄÓï¾ä£º
SELECT * from mytable WHERE category_id=1;
×îÖ±½ÓµÄÓ¦¶ÔÖ®µÀ£¬ÊÇΪcategory_id½¨Á¢Ò»¸ö¼òµ¥µÄË÷Òý£º
CREATE INDEX mytable_categoryid
¡¡ON mytable (category_id);
OK£¬¸ã¶¨£¿Ïȱð¸ßÐË£¬Èç¹ûÄãÓв»Ö¹Ò»¸öÑ¡ÔñÌõ¼þÄØ£¿ÀýÈ磺
SELECT * from mytable WHERE category_id=1 AND user_id=2;
ÄãµÄµÚÒ»·´Ó¦¿ÉÄÜÊÇ£¬ÔÙ¸øuser_id½¨Á¢Ò»¸öË÷Òý¡£²»ºÃ£¬Õâ²»ÊÇÒ»¸ö×î¼ÑµÄ·½·¨¡£Äã¿ÉÒÔ½¨Á¢¶àÖØµÄË÷Òý¡£
CREATE INDEX mytable_categoryid_userid ON mytable (category_id,user_id);
×¢Òâµ½ÎÒÔÚÃüÃûʱµÄϰ¹ßÁËÂð£¿ÎÒʹÓÃ"±íÃû_×Ö¶Î1Ãû_×Ö¶Î2Ãû"µÄ·½Ê½¡£ÄãºÜ¿ì¾Í»áÖªµÀÎÒΪʲôÕâÑù×öÁË¡£
ÏÖÔÚÄãÒѾΪÊʵ±µÄ×ֶν¨Á¢ÁËË÷Òý£¬²»¹ý£¬»¹ÊÇÓе㲻·ÅÐİɣ¬Äã¿ÉÄÜ»áÎÊ£¬Êý¾Ý¿â»áÕæÕýÓõ½ÕâЩË÷ÒýÂ𣿲âÊÔһϾÍOK£¬¶ÔÓÚ´ó¶àÊýµÄÊý¾Ý¿âÀ´Ëµ£¬ÕâÊǺÜÈÝÒ׵ģ¬Ö»ÒªÊ¹ÓÃEXPLAINÃüÁ
EX
Ïà¹ØÎĵµ£º
ÔÚÊý¾Ý¿âÓ¦Óã¬ÎÒÃǾ³£ÒªÓõ½Î¨Ò»±àºÅ¡£ÔÚMySQLÖпÉͨ¹ý×ֶεÄAUTO_INCREMENTÊôÐÔÀ´×Ô¶¯Éú³É¡£MySQLÖ§³Ö¶àÖÖÊý¾Ý±í£¬Ã¿ÖÖÊý¾Ý±íµÄ×ÔÔöÊôÐÔ¶¼ÓÐËù²»Í¬¡£
ISAM±í
Èç¹û°ÑÒ»¸öNULL²åÈëµ½Ò»¸öAUTO_INCREMENTÊý¾ÝÁÐÀïÈ¥£¬MySQL½«×Ô¶¯Éú³ÉÏÂÒ»¸öÐòÁбàºÅ¡£±àºÅ´Ó1¿ªÊ¼£¬²¢1Ϊ»ùÊýµÝÔö¡£
µ±²åÈë¼Ç¼ʱ£¬Ã»ÓÐΪAUTO_INCREMENTÃ÷È ......
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 ex tinyint n ......
LinuxϽøÐÐMYSQLµÄC++±à³ÌÆð²½ÊÖ¼Ç
Ê×ÏȰ²×°±ØÐèµÄ¿ª·¢°ü
sudo apt-get install gcc g++ libgcc1 libg++ make gdb
°²×°MYSQLµÄCÓïÑÔ¿ª·¢°ü
sudo apt-get install libmysql++-dev libmysql++2c2a libmysqlclient15-dev libmysqlclient15off
......
Ö÷´Ó·þÎñÆ÷±íÀàÐ͵ÄÑ¡Ôñ
Ò»°ãµÄ¹²Ê¶ÊÇÖ÷·þÎñÆ÷ʹÓÃinnodb£¬ÊÂÎñ£¬ÐÐËøµÈ¹¦ÄÜÊÇmyisamËùûÓе쬶ÔÐ޸IJÙ×÷¶øÑÔ£¬Ëü¸ü¸ßЧ£»´Ó·þÎñÆ÷ʹÓÃmyisam£¬È«ÎļìË÷¹¦ÄÜÊÇinnodbËùûÓеģ¬¶Ô²éѯ²Ù×÷¶øÑÔ£¬Ëü¸ü¸ßЧ¡£ÕâÑù¾Í¿ÉÒÔ¸÷¾¡ÆäÄÜ¡£
ºÇºÇ£¬Ö÷´Ó¿â¸÷˾ÆäÖ°£¬Ö÷¿â£º×î¿ìµÄËÙ¶È×öÌí¼Óɾ³ýÐ޸IJÙ×÷£¬´Ó¿â£¬×î¿ìµÄËÙ¶È×ö²éѯ²Ù×÷
......