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

MySQL Reference ManualÖÐÎİæ

MySQL Reference Manual for version 4.1.0-alpha.
¡¡ÒëÕßÐò
¡¡ÁÐÀàÐÍÓ뺯ÊýË÷Òý
6 MySQL ÓïÑԲο¼

6.1 ÓïÑԽṹ

6.1.1 ÎÄ×Ö£ºÔõôд×Ö·û´®ÓëÊý×Ö

6.1.1.1 ×Ö·û´®

 
6.1.1.2 Êý×Ö

 
6.1.1.3 Ê®Áù½øÖÆÖµ

 
6.1.1.4 NULL
Öµ

 
6.1.2 Êý¾Ý¿â¡¢±í¡¢Ë÷Òý¡¢ÁкͱðÃû

 
6.1.3 Ãû×ֵĴóСдÃô¸ÐÐÔ

 
6.1.4 Óû§±äÁ¿

 
6.1.5 ϵͳ±äÁ¿

 
6.1.6 ×¢Ê;䷨

 
6.1.7 MySQL ¶Ô±£Áô×ÖÌôÌÞÂð£¿

 
6.2 ÁÐÀàÐÍ

6.2.1 Êý×ÖÀàÐÍ

 
6.2.2 Date ºÍ Time ÀàÐÍ

6.2.2.1 Y2K ÎÊÌâºÍÈÕÆÚÀàÐÍ

 
6.2.2.2 DATETIME¡¢DATE ºÍ TIMESTAMP ÀàÐÍ

 
6.2.2.3 TIME ÀàÐÍ

 
6.2.2.4 YEAR ÀàÐÍ

 
6.2.3 ×Ö·û´®ÀàÐÍ

6.2.3.1 CHAR ºÍ VARCHAR ÀàÐÍ

 
6.2.3.2 BLOB ºÍ TEXT ÀàÐÍ

 
6.2.3.3 ENUM ÀàÐÍ

 
6.2.3.4 SET ÀàÐÍ

 
6.2.4 ΪÁÐÑ¡ÔñÕ


Ïà¹ØÎĵµ£º

MysqlÊý¾ÝÌáÈ¡Æ÷

        ¼¸¸öÔÂǰ£¬ÊÜһλÀÏʦµÄίÍУ¬Òª°ïËû×öÒ»¸ö¹ØÏµÊý¾Ý¿âģʽÐÅÏ¢ÌáÈ¡µÄСÏîÄ¿£¬Ö÷ÒªµÄ¹¦ÄÜʵÏÖ¾ÍÊǽ«¹ØÏµÊý¾Ý¿âµÄ±í½á¹¹ºÍ×ֶεÄÐÅϢͨ¹ý±í¸ñµÄÐÎʽչʾ³öÀ´¡£ÎÒͨ¹ý´ÓÍøÉÏËѼ¯×ÊÁÏÒÔ¼°·­Êé²éÕÒ£¬ÏÈʵÏÖÁËÒ»¸ömysqlµÄÊý¾ÝÌáÈ¡Æ÷¡£Ïȸø´ó¼Ò·ÖÏíһϡ£ÉÔºóµÄ¼¸ÌìÄÚ»á°ÑÁíÒ»¸ömysql¹ ......

mysql Ïà¹ØÍøÖ·...

£©MySql ÖÐÎÄÍø£ºhttp://imysql.cn/onlinedoc
£©MySQL ÖÐÎÄÉçÇø £ºhttp://www.mysql.net.cn/
£©MySql °Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/24816.htm
²Î¿¼×ÊÁÏ£º
MySql°æ±¾¹¹¼Ü¼°Ë÷ÒýÎļþ½éÉÜ 
Linux·þÎñÆ÷ÅäÖ÷½°¸MySQL 
WinodwsÏÂIIS/Apache PHP MySQLµÄ°²×°ÅäÖà
³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ& ......

MySQL³£ÓõÄһЩÓÐЧÃüÁîÂÞÁÐ

¼ò¼òµ¥µ¥µÄÂÞÁÐһЩÈÕ³£³£ÓõÄMySQLÃüÁî¡£
show variables;
²é¿´Êý¾Ý¿âÅäÖõÄһЩÅäÖÃÏî
show status;
²é¿´µ±Ç°Æô¶¯µÄMySQL״̬
select @@autocommit;
²é¿´MySQLµ±Ç°Ö´ÐÐSQLµÄÌá½»ÀàÐÍ£¨ÊÇ·ñ×Ô¶¯Ìá½»£©
\s
µ±Ç°Á¬½ÓÊý¾Ý¿âÃû£¬Óû§Ãû£¬MySQL°æ±¾£¬×Ö·û¼¯µÈµÈ¡£
show create table table_name \G
²é¿´´´½¨±íµÄSQLÓï ......

¹ØÓÚÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ½â´ð£¨×Ü½áÆª£©

 ¹ØÓÚÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ½â´ð£¨×Ü½áÆª£©
ÕûÀíÁËÒÔÏÂËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨,Ö÷ÒªÊÇÓÐʱºò×Ô¼ºÓöµ½ÁËÕâ¸öÎÊÌâ²»ÖªµÀÔõô¸ãÁË£¬µ±È»Èç¹ûÄܸø¹ã´óµÄPHPer½â¾öÎÊÌâÒ²ÊÇÎÒµÄÈÙÐÒ°¡£¬ºÇºÇ¡£
·½·¨1£º ÓÃSET PASSWORDÃüÁî
¡¡¡¡mysql -u root
¡¡¡¡mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ