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

Mysql½ø»¯ÂÛ2


MysqlËùÖ§³ÖµÄÒýÇæÄ¿Ç°ÓÐÒÔϼ¸ÖÖ£º
MyISAM,InnoDB,MERGE,MEMORY(HEAR),BDB(BerkeleyDB),EXAMPLE,FEDERATED,ARCHIVE,CSV,BLACKHOLE.
ΪʲôҪÓÐÕâô¶àÒýÇ棿Ö÷ÒªÊÇMysqlÊÇÒ»¿î¼«ÎªÇ¿´óµÄÊý¾Ý¿â£¬ËüÊÊÓ¦ºÜ¶à²»Í¬µÄÔËÐл·¾³£¬ÎªÁËÂú×ã¸÷ÖÖ²»Í¬µÄÔËÐл·¾³Óë´æ´¢·½°¸µÄÐèÒª£¬ÕâЩËÑË÷ÒýÇæÒ²¾ÍÓ¦Ô˶øÉú£¨²»¹âÊÇΪÁËÅäºÏMysql£©¡£
¼òµ¥µÄ˵£¬¾ÍÊÇÒ»¸öMysqlÊý¾Ý¿â£¬ÓÐןܶàµÄ´æ´¢·½°¸¡£ÓÉÓÚ²»Í¬µÄ´æ´¢ÒýÇæµÄ´æ´¢·½°¸Óв»Í¬µÄÓÅÊÆÓë²»×㣬ͨ¹ý¶Ô²»Í¬µÄËÑË÷ÒýÇæµÄÖ§³Ö£¬¶ø´ïµ½¸üΪǿ´ó£¬¸üÓе¯ÐÔµÄÊý¾Ý¿â¡£
ÈÃÎÒÃÇÏÈ´ÓÈý¸öÌåϵ½á¹¹¿ªÊ¼£º
A-Mysql·Ö²ãÌåϵ½á¹¹
ÆäÖÐÓ¦ÓòãΪËùÓеÄÓû§ÌṩµÄ½Ó¿Ú£¬Âß¼­²ã°üÀ¨ÁËËùÓкËÐŦÄܵÄʵÏÖ£¬ÎïÀí²ãÓÃÀ´¸ºÔð½«Êý¾Ý´æ´¢ÔÚÓ²ÅÌÉÏ¡£Í¼Öп¿ÓÒϲ»¶µÄÂß¼­²ãµÄ×é³É£¬²éѯ´¦Àí×Óϵͳ£¬ÊÂÎñ¹ÜÀí×Óϵͳ£¬»Ö¸´¹ÜÀí×ÓϵͳºÍ´æ´¢¹ÜÀí×Óϵͳ¹²Í¬×é³ÉÁËMysqlµÄÂß¼­²ã¡£Í¨¹ý´æ´¢¹ÜÀí(Storage Management)À´¹ÜÀíÿ¸ö´æ´¢ÒýÇæ(Storage Engine)¡£
B-ÏêϸÌåϵ½á¹¹
C-MysqlÌåϵ
MysqlÖ§³Ö¶à¸ö´æ´¢ÒýÇæÓÃÀ´¶Ô²»Í¬µÄ±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£Mysql´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎﰲȫ±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎﰲȫ±íµÄÒýÇæ¡£Äã¿ÉÒÔ°´ÕÒϲºÃͨ¹ýÅäÖÃMysqlÀ´ÔÊÐí»ò½ûÖ¹ÈÎÒ»ÒýÇæ¡£*ͨ¹ý¸ü¸ÄSTORAGE_ENGINEÀ´ÅäÖÃĬÈϵĴ洢ÒýÇæ¡£
1.MyISAM¹ÜÀí·ÇÊÂÎï±í¡£ËüÌṩ¸æËß´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡£MyISAMÔÚËùÓÐMysqlÅäÖÃÀï±»Ö§³Ö£¬ÎªMysqlĬÈϵĴ洢ÒýÇæ¡£ËüʵÔÚWeb£¬Êý¾Ý²Ö¿âºÍÆäËûÓ¦Óû·¾³ÏÂ×ʹÓõĴ洢ÒýÇæ¡£
2.MEMORY´æ´¢ÒýÇæÌṩ“ÄÚ´æÖД±í£¬±»È·¶¨ÎªHEAPÒýÇæ.MEMORY½«ËùÓÐÊý¾Ý±£´æÔÚRAMÖУ¬ÔÚÐèÒª¿ìËÙ²éÕÒÒýÓúÍÆäËûÀàËÆÊý¾ÝµÄ»·¾³Ï£¬¿ÉÒÔÌṩ¼«¿ìµÄ·ÃÎÊ¡£
3.MERGE´æ´¢ÒýÇæÔÊÐí¼¯ºÏ½«±»´¦ÀíͬÑùµÄMyISAM±í×÷Ϊһ¸öµ¥¶ÀµÄ±í¡£¾ÍÏñMyISAMÒ»Ñù£¬MEMORYºÍMERGE´æ´¢ÒýÇæ´¦Àí·ÇÊÂÎï±í£¬ÓëMEMORYÒýÇæĬÈÏ°üº¬ÓëMysqlÖС£ÔÊÐíMysql DBA»ò¿ª·¢ÈËÔ±½«Ò»ÏµÁеÈͬµÄMyISAM±íÒÔÂß¼­·½Ê½×éºÏÔÚÒ»Æ𣬲¢×÷Ϊ1¸ö¶ÔÏóÒýÓÃËüÃÇ¡£¶ÔÓÚÖîÈçÊý¾Ý²Ö¿âµÈVLDB»·¾³Ê®·ÖÊʺϡ£
4.InnoDBºÍBDB´æ´¢ÒýÇæÌṩÊÂÎﰲȫ±í¡£BDB±»°üº¬ÔÚΪ֧³ÖËüµÄ²Ù×÷ϵͳ·¢²¼µÄMysql-max¶þ½øÖÆ·Ö·¢°æÖС£InnoDBҲĬÈÏ°üÀ¨ÔÚÆäÖС£InnoDB¶àÓÃÓÚÊÂÎï´¦ÀíÓ¦ÓóÌÐò£¬¾ßÓÐÖÚ¶àÌØÐÔ£¬°üÀ¨ACIDÊÂÎïÖ§³Ö¡£¶øBDB¿ÉÒÔÌæ´úInnoDBµÄÊÂÎïÒýÇ棬֧³ÖCOMMIT,ROLLBACKºÍÆäËûµÄÊÂÎïÌØÐÔ¡£
5.ECAMPLE´æ´¢ÒýÇæÊÇÒ»¸ö"´æ¸ù"ÒýÇ档ͨ¹ý´ËÒýÇæ´´½¨±í£¬µ«Ã»ÓÐÊý¾Ý±»´æ´¢ÓÚÆäÖлò´ÓÖмìË÷¡£Õâ¸öÒýÇæµÄÄ¿µÄÊÇ


Ïà¹ØÎĵµ£º

mysql»ù´¡²Ù×÷

 1¡¢ÏµÍ³¹ÜÀí
¡¡¡¡mysql -hÖ÷»úµØÖ· -uÓû§Ãû -p
¡¡¡¡Á¬½ÓMYSQL(ÔÚmysql/bin)
¡¡¡¡exit
¡¡¡¡Í˳öMYSQLÃüÁî
¡¡¡¡mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë passwordÐÂÃÜÂë
¡¡¡¡ÐÞ¸ÄÃÜÂë(ÔÚmysql/bin)
¡¡¡¡grantselect[insert][,update][,delete]onÊý¾Ý¿â.*toÓû§Ãû@localhost("%"£¬ ±íʾÈκÎÖ÷»ú)identifiedby "ÃÜÂë"
¡¡¡¡ ......

mysqlÔ¶³ÌȨÏÞÉèÖÃ

 1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
   ²é¿´½á¹û£¬Ö´ÐУº
   use mysql;
   select host,user,p ......

MySql¼òÒױʼÇ


MySql¼òÒױʼÇ
 
 
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
 
 
2£º´ò¿ªmysqlµÄCMD
 
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHA ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

Mysql½ø»¯ÂÛ1

1.Ëü¿ÉÒÔ±»·ÖΪÈýÀࣺÊý×ÖÀàÐÍÈÕÆÚÀàºÍʱ¼äÀàÐÍ£¬×Ö·û´®ÀàÐÍ¡£
ÁÐÀàÐÍÓÃÓÚÃèÊö:
M£ºÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨ÏÔʾ³ß´çΪ255.
D£ºÊÊÓÃÓÚ¸¡µãÀàÐͲ¢Ö®³õ¸úËæÔÚÊ®½øÖÆСÊýµãºóµÄÊýÂëµÄÊýÁ¿¡£×î´óµÄ¿ÉÄÜÖµÊÇ30£¬µ«ÊDz»Ó¦´óÓÚM.
2.·½À¨ºÅ("[","]")Ö¸³ö¿ÉÑ¡µÄÀàÐÍÐÞÊηûµÄ²¿·Ö£®
£ªÈôÖ¸¶¨ÁËÁÐÀàÐÍΪZEROFILL,MYSQL½«¸Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ