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

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò

MySQLÓï¾äÓÅ»¯µÄ»ù±¾Ô­Ôò£º 
¡ô1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£ 
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£Ò»°ãÀ´Ëµ£º 
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾­³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by·¢ÉúµÄÁУ¬¿É¿¼Âǽ¨Á¢Èº¼¯Ë÷Òý£» 
b.¾­³£Í¬Ê±´æÈ¡¶àÁУ¬ÇÒÿÁж¼º¬ÓÐÖØ¸´Öµ¿É¿¼Âǽ¨Á¢×éºÏË÷Òý£» 
c.×éºÏË÷ÒýÒª¾¡Á¿Ê¹¹Ø¼ü²éѯÐγÉË÷Òý¸²¸Ç£¬Æäǰµ¼ÁÐÒ»¶¨ÊÇʹÓÃ×îÆµ·±µÄÁС£Ë÷ÒýËäÓÐÖúÓÚÌá¸ßÐÔÄܵ«²»ÊÇË÷ÒýÔ½¶àÔ½ºÃ£¬Ç¡ºÃÏà·´¹ý¶àµÄË÷Òý»áµ¼ÖÂϵͳµÍЧ¡£Óû§ÔÚ±íÖÐÿ¼Ó½øÒ»¸öË÷Òý£¬Î¬»¤Ë÷Òý¼¯ºÏ¾ÍÒª×öÏàÓ¦µÄ¸üй¤×÷¡£ 
¡ô2¡¢ÔÚº£Á¿²éѯʱ¾¡Á¿ÉÙÓøñʽת»»¡£ 
¡ô3¡¢ORDER BYºÍGROPU BYʹÓÃORDER BYºÍGROUP BY¶ÌÓÈκÎÒ»ÖÖË÷Òý¶¼ÓÐÖúÓÚSELECTµÄÐÔÄÜÌá¸ß¡£ 
¡ô4¡¢ÈκζÔÁеIJÙ×÷¶¼½«µ¼Ö±íɨÃ裬Ëü°üÀ¨Êý¾Ý¿âº¯Êý¡¢¼ÆËã±í´ïʽµÈµÈ£¬²éѯʱҪ¾¡¿ÉÄܽ«²Ù×÷ÒÆÖÁµÈºÅÓұߡ£ 
¡ô5¡¢IN¡¢OR×Ӿ䳣»áʹÓù¤×÷±í£¬Ê¹Ë÷ÒýʧЧ¡£Èç¹û²»²úÉú´óÁ¿Öظ´Öµ£¬¿ÉÒÔ¿¼ÂǰÑ×Ó¾ä²ð¿ª¡£²ð¿ªµÄ×Ó¾äÖÐÓ¦¸Ã°üº¬Ë÷Òý¡£ 
¡ô6¡¢Ö»ÒªÄÜÂú×ãÄãµÄÐèÇó£¬Ó¦¾¡¿ÉÄÜʹÓøüСµÄÊý¾ÝÀàÐÍ£ºÀýÈçʹÓÃMEDIUMINT´úÌæINT 
¡ô7¡¢¾¡Á¿°ÑËùÓеÄÁÐÉèÖÃΪNOT NULL£¬Èç¹ûÄãÒª±£´æNULL£¬ÊÖ¶¯È¥ÉèÖÃËü£¬¶ø²»ÊǰÑËüÉèΪĬÈÏÖµ¡£ 
¡¡¡¡ 
¡ô8¡¢¾¡Á¿ÉÙÓÃVARCHAR¡¢TEXT¡¢BLOBÀàÐÍ 
¡ô9¡¢Èç¹ûÄãµÄÊý¾ÝÖ»ÓÐÄãËùÖªµÄÉÙÁ¿µÄ¼¸¸ö¡£×îºÃʹÓÃENUMÀàÐÍ 
¡ô10¡¢ÕýÈçgraymiceËù½²µÄÄÇÑù£¬½¨Á¢Ë÷Òý¡£ 
ÒÔÏÂÊÇÎÒ×öµÄÒ»¸öʵÑ飬¿ÉÒÔ·¢ÏÖË÷ÒýÄܼ«´óµØÌá¸ß²éѯµÄЧÂÊ£º 
ÎÒÓÐÒ»¸ö»áÔ±ÐÅÏ¢±íusers£¬Àï±ßÓÐ37365ÌõÓû§¼Ç¼£º 
ÔÚ²»¼ÓË÷ÒýµÄʱºò½øÐвéѯ£º 
sqlÓï¾äA: 
select * from users where username like '%Ðí%';
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º1.40,0.54,0.54,0.54,0.53,0.55,0.54 ¹²ÕÒµ½960Ìõ¼Ç¼ 
sqlÓï¾äB: 
select * from users where username like 'Ðí%';
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º0.53,0.53,0.53,0.54,0.53,0.53,0.54,0.54 ¹²ÕÒµ½836Ìõ¼Ç¼ 
sqlÓï¾äC: 
select * from users where username like '%Ðí';
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º0.51,0.51,0.52,0.52,0.51,0.51,0.52,0.51 ¹²ÕÒµ½7Ìõ¼Ç¼ 
Ϊusername


Ïà¹ØÎĵµ£º

MySQL²éѯЧÂÊÓÅ»¯ Ìí¼ÓË÷ÒýÃüÁî


1.PRIMARY KEY£¨Ö÷¼üË÷Òý£©
mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
2.UNIQUE(ΨһË÷Òý)
mysql>ALTER TABLE `table_name` ADD UNIQUE (
`column`
)
3.INDEX(ÆÕͨË÷Òý)
mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column` )
4.FULLTEX ......

ÈÃmemcachedºÍmysql¸üºÃµÄ¹¤×÷

http://www.itlearner.com/article/2009/4325.shtml
Õâ´ÎÊÇFotolog
µÄ¾­Ñ飬´«ËµÖбÈFlickr¸ü´óµÄÍøÕ¾
£¬FotologÔÚ21̨·þÎñ
Æ÷Éϲ¿ÊðÁË51¸ömemcachedʵÀý£¬×ܼÆÓÐ254G»º´æ¿Õ¼ä¿ÉÓ㬻º´æÁ˶à´ï175GµÄÄÚÈÝ£¬Õâ¸öÊýÁ¿±ÈºÜ¶àÍøÕ¾µÄÊý¾Ý¿â¶¼Òª´óµÄ¶à£¬Ô­ÎÄÊÇA Bunch of Great Strategies for Using Memcached and MySQL Bet ......

MYSQLѧϰ

MYSQLÓжàÖÖ´æ´¢ÒýÇæºÍ±íÀàÐÍ£¬InnoDBºÍBDBÖ§³ÖÊÂÎñ£¬Èç¹ûҪʹÓÃÊÂÎñ£¬±íµÄÀàÐ;ÍÓ¦¸ÃÊÇInnoDB.
Ìá¸ß±íµÄÐÔÄÜ£º
1¡¢ÓÃ×îСµÄÊý¾ÝÀàÐÍ¡£Õ¼ÓÿռäС£¬½ÚÊ¡´ÅÅ̿ռäºÍÄÚ´æ¡£
2¡¢±í¸ñµÄÖ÷Ë÷ÒýÒª¾¡¿ÉÄܵĶ̣¬ÒÔÃ÷ÏÔÌá¸ßЧÂÊ¡£
3¡¢Ë÷Òý×îºÃ½¨ÔÚΨһµÄÁÐÉÏ£¬Ë÷ÒýÔ½¶Ì£¬ËÙ¶ÈÔ½¿ì¡£
4¡¢¶àÁÐË÷Òý±ØÐë°üº¬×î×ó±ßµÄǰ׺²ÅÓÐЧ¡£ ......

sqliteºÍpdo mysqlµÄÊý¾Ý¿â²Ù×÷

½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......

ÓÅ»¯MYSQLÊý¾Ý¿âµÄ·½·¨

1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁʹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ