MySQL²éѯÓÅ»¯ Ë÷Òý
MySQLË÷Òý
MySQL²éѯÓÅ»¯×îÖØÒªµÄµ±Êô½¨Á¢ÕýÈ·µÄË÷Òý£¬Ã»ÓÐË÷Òý£¬Ãæ¶Ôº£Á¿Êý¾Ý£¬Ò»ÇеÄÓÅ»¯´¿Êô¿Õ»°¡£Ê²Ã´ÊÇË÷Òý£¿Ë÷ÒýΪʲôÄÇôÖØÒªÄØ£¿ÕâЩÎÊÌâÕâÀï¾Í²»Ì¸ÁË£¬»¹ÊÇÏÈдÏÂÎÒÊ×´ÎÓÅ»¯MySQL²éѯº£Á¿Êý¾ÝµÄÐĵðɣ¬Êý¾Ý¿â±íÀàÐÍÊÇMyISAM¡£
Èç¹û¼òµ¥µÄÒ»¸ö²éѯÓï¾ä£¬MySQL²éѯËٶȻ¹ÊDZȽϿ͹۵ģ¬ÀýÈçselect col_name from table [where conditions]¼´Ê¹Êý¾ÝÁ¿ÔÙ´ó£¬Ò²ÊǷdz£Ö®¿ì¡£µ«ÊÇÎÒÃÇƽʱ¾ßÌåʹÓÃÍùÍùÐèÒª¼¸ÕűíµÄÁ¬½Ó²ÅÄܵõ½Êý¾Ý£¬ÉõÖÁÊǽøÐÐorder by¡¢group by£¬Õâ¸öʱºòÈç¹ûûÓÐË÷Òý£¬¾ÍÏÔµÃÒì³£µÄÂý¡£±íµÄÁ¬½Ó¡¢order by¡¢group byÍùÍù»¹Òª¼ÓÉÏÌõ¼þ£¬Òò´Ë´´½¨¸´ºÏË÷ÒýµÄÇé¿ö±È½Ï¶à¼û¡£
¸´ºÏË÷ÒýÓÐÒ»¸öÖØÒªµÄÔÔòÊÇÆ¥Åä×î×óǰ׺£¬Ò»°ãÈç¹ûÆ¥ÅäÁË×î×óǰ׺£¬¾Í²»ÐèÒªÔÙµ¥¶À½¨Á¢Ò»¸öµ¥Ò»Ë÷ÒýÁË£¬Ë÷Òý¹ý¶àÖ»»á¼õÂý²éѯËٶȡ£ÀýÈ罨Á¢ÁËcreate index ComplexIndex on table£¨Owner£¬Type£¬Permission£©¾ÍÏ൱ÓÚ°üº¬ÁË£¨Owner£¬Type£©ºÍ£¨Owner£©ÕâÁ½¸öË÷Òý¡£ÏÈдÕâЩ°É£¬´ýÐø¡£
Ïà¹ØÎĵµ£º
Love in coding...
Free and Susan
[Òý]MySQL INNODBÀàÐͱíµÄÍâ¼ü¹ØÁªÉèÖÃ
Here is a simple example that relates parent and child tables through a single-column foreign key:
CREATE TABLE parent (id INT NOT NULL,
......
ÓÉÓÚÄÜÖ±½ÓÔÚMYSQLÊý¾Ý¿âÀïÌí¼ÓÖÐÎÄÊý¾Ý,²¢ÇÒÄÜÕý³£ÏÔʾ,˵Ã÷ÎÒµÄ±í¶¼Ê¹ÓÃÁËÕýÈ·µÄ×Ö·û±àÂë,¾¹ý²é¿´ºó,È·ÈÏÁË,ÎÒÈ«²¿µÄ±íÒÔ¼°×ֶζ¼Ê¹ÓÃÁËUTF-8µÄ±àÂë,µ«ÊÇΪʲô³ÌÐòÌí¼ÓµÄÖÐÎÄÊý¾Ý¾Í²»ÐÐÄØ?
Æäʵ,ÔÒòÔÚÓÚMYSQL·þÎñÆ÷ʹÓõÄĬÈϱàÂë,ÒÔ¼°Êý¾Ý¿âµÄĬÈϱàÂë,ºÜ¶àÈËÒѾºÜСÐĵÄÔÚ½¨Á¢±íʱ¹Ø×¢±íµÄ×Ö·û±àÂë,È´ºöÂÔÁËÊý¾Ý¿â ......
Ðè×¢ÒâÒÔÏÂÈýµã£º
1¡¢´´½¨Êý¾Ý¿âµÄʱºò£ºCREATE DATABASE `database`
CHARACTER SET 'utf8'
  ......
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......
ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i38 ......