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Íü¼Ç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µÄ·ÃÎ ......
mysqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö£¨×ܽáƪ£©
µÚÒ»½â¾ö·½·¨£º
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
......
Ô±¾µÄÄ¿µÄÊǽ«Êý¾Ý¿â´ÓMS SQL 2000ǨÒƵ½MySQLÖУ¬µ«ÌáʾJDBCÁ¬½Óʧ°Ü£¬ÎÞÄÎÖ®¼«£¬Ö»ºÃÑ¡ÔñÖмäÇÅÁºAccessÍê³ÉÕâÏîÁîÈËÌÖÑáµÄ¹¤×÷ÁË¡£
´ó¸Å²½ÖèÈçÏ£º
1£¬´ÓMS SQL 2000½«Êý¾Ýµ¼³öµ½AccessÖУ¬ÓÐ¹Ø±í¶¨ÒåºÃÖ÷¼üºÍ×Ô¶¯±àºÅ²¿·Ö²»È»Ç¨ÒƺóÓÖµÃÐÞ¸ÄMySQLµÄ±í¡£
2£¬ÐÞ¸ÄAccess±íÖйÜÀíÔ±×é¡¢¹ÜÀíÔ±µÄȨÏÞ£¬±£Ö¤AccessµÄÄÚÖà ......