Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ΪÁÐÑ¡ÔñÕ


Ïà¹ØÎĵµ£º

½â¶ÁOracle¼Æ»®£ºSolaris½«±»Õü¾È MySQL¼ÌÐøÇ°Í¾Î´²·


¡¾51CTO.com¶À¼ÒÌØ¸å¡¿Ãæ¶Ô¾ª»ÅµÄ¿Í»§ºÍ¹ã·ºÖÊÒɵÄýÌ壬Oracle¹Ù·½×î½üÖÕÓÚ³ö°ñ°²Ãñ£¬ÄDZãÊÇÒ»¸öÒÔ“SUN CUSTOMERS ,Oracle Plans To£º”Ϊ´ó±êÌâµÄ¹ã¸æ¡£Ö±Òë¹ýÀ´±ã¹ýÀ´¿ÉÖªµÀ£¬Oracle½«Òª¼Ó´óSPARCºÍSolarisµÄͶÈëÁË£¬¶ø´óÀϰ尣ÀïÉ­Ò²ÏòIBMÓ²¼þÏÂÁËÕ½Ê飬Éù³ÆOracle½«×îÖÕÓ®µÃÕⳡ¾ºÕù……
&n ......

ÈçºÎÐÞ¸ÄMySQL rootÃÜÂë

Íü¼ÇMySQL ROOTÃÜÂëÊÇÔÚMySQLʹÓÃÖкܳ£¼ûµÄÎÊÌ⣬¿ÉÊÇÓкܶàÅóÓѲ¢²»»áÖØÖÃROOTÃÜÂ룬Äǽпడ£¬ÎÒÓÐÉîÓид¥£¬ÌØÐ´´ËÎÄÕÂÓë´ó¼Ò½»Á÷£º
 
1¡¢±à¼­MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini
//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf ......

MYSQLÍü¼ÇROOTÃÜÂëºó£¿

 
 MYSQLÍü¼ÇROOTÃÜÂëºó£¿
 
ÐÞ¸ÄMySQLµÄµÇ¼ÉèÖãº
1.È¡ÏûȨÏÞ¹ÜÀí
±à¼­ /mysql5.1/my.ini
ÔÚ[mysqld]µÄ¶ÎÖмÓÉÏÒ»¾ä£ºskip-grant-tables
ÀýÈ磺
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
skip-grant-tables
Ä¿µÄÊÇΪÁË£º
Ìø¹ýMySQLµÄ·ÃÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ