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

Mysql½ø»¯ÂÛ1

1.Ëü¿ÉÒÔ±»·ÖΪÈýÀࣺÊý×ÖÀàÐÍÈÕÆÚÀàºÍʱ¼äÀàÐÍ£¬×Ö·û´®ÀàÐÍ¡£
ÁÐÀàÐÍÓÃÓÚÃèÊö:
M£ºÖ¸³ö×î´óµÄÏÔʾ³ß´ç¡£×î´óµÄºÏ·¨ÏÔʾ³ß´çΪ255.
D£ºÊÊÓÃÓÚ¸¡µãÀàÐͲ¢Ö®³õ¸úËæÔÚÊ®½øÖÆÐ¡ÊýµãºóµÄÊýÂëµÄÊýÁ¿¡£×î´óµÄ¿ÉÄÜÖµÊÇ30£¬µ«ÊDz»Ó¦´óÓÚM.
2.·½À¨ºÅ("[","]")Ö¸³ö¿ÉÑ¡µÄÀàÐÍÐÞÊηûµÄ²¿·Ö£®
£ªÈôÖ¸¶¨ÁËÁÐÀàÐÍΪZEROFILL,MYSQL½«¸ÃÁÐ×Ô¶¯µØÔö¼ÓUNSIGNEDÊôÐÔ¡£
TINYINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öºÜСµÄÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-128µ½127£¬ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½255.
SMALLINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öСÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-32768µ½32767,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½65535.
MEDIUMINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öÖеȴóСÕûÊý.ÓзûºÅ¶î·¶Î§ÊÇ-8388608µ½2147483647,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½16777215.
INT[(M)][UNSIGNED][ZEROFILL]:Ò»¸öÕý³£´óСÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-2147483648µ½2147483647,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½4294967295.
INTEGER[(M)][UNSIGNED][ZEROFILL]:
ÕâÊÇÒ»¸öintµÄͬÒå´Ê¡£¿ÉÒÔ˵ÊÇINTµÄ¼ò³Æ.
BIGINT[(M)][UNSIGNED][ZEROFILL]:Ò»¸ö´óÕûÊý¡£ÓзûºÅµÄ·¶Î§ÊÇ-9223372036857754775808µ½9223372036854775807,ÎÞ·ûºÅµÄ·¶Î§ÊÇ0µ½18446744073709551615¡£
FLOAT[(M,D)][ZEROFILL]:Ò»¸öС£¨µ¥¾«ÃÜ£©¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ.ÔÊÐíµÄÖµÊÇ-3.402823466E+38µ½-1.175494351E-38£¬0 ºÍ1.175494351E-38µ½3.402823466E+38¡£MÊÇÏÔʾ¿í¶È¶øDÊÇСÊýµÄλÊý¡£Ã»ÓвÎÊýµÄFLOAT»òÓÐ<24µÄÒ»¸ö²ÎÊý±íʾһ¸öµ¥¾«Ãܸ¡µãÊý×Ö¡£
DOUBLE[(M,D)][ZEROFILL]:Ò»¸öÕý³£´óС£¨Ë«¾«ÃÜ£©¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ¡£ÔÊÐíµÄÖµÊÇ-1.7976931348623157E+308µ½-2.2250738585072014E-308¡¢ 0ºÍ2.2250738585072014E-308µ½1.7976931348623157E+308¡£MÊÇÏÔʾ¿í¶È¶øDÊÇСÊýλÊý¡£Ã»ÓÐÒ»¸ö²ÎÊýµÄDOUBLE»òFLOAT(X)£¨25 < = X < = 53£©´ú±íÒ»¸öË«¾«Ãܸ¡µãÊý×Ö¡£
DOUBLE PRECISION[(M,D)][ZEROFILL];REAL[(M,D)][ZEROFILL]:ÕâЩ¶¼ÊÇDOUBLEµÄͬÒå´Ê.
DECIMAL[(M[,D])][ZEROFILL]:Ò»¸öδѹËõ(unpack)µÄ¸¡µãÊý×Ö¡£²»ÄÜÎÞ·ûºÅ¡£ÐÐΪÈçͬһ¸öCHARÁУº“δѹËõ”Òâζ×ÅÊý×Ö×÷Ϊһ¸ö×Ö·û´®±»´æ´¢£¬ÖµµÄÿһλʹÓÃÒ»¸ö×Ö·û¡£Ð¡Êýµã£¬²¢ÇÒ¶ÔÓÚ¸ºÊý£¬“-”·ûºÅ²»ÔÙMÖмÆËã¡£Èç¹ûDÊÇ0£¬Öµ½«Ã»ÓÐСÊýµã»òÕßСÊý²¿·Ö¡£DECIMALÖµµÄ×î´ó·¶Î§ÓëDOUBLEÏàͬ£¬µ«ÊǶÔÒ»¸ö¸ø¶¨µÄDECIMALÁУ¬Êµ¼ÊµÄ·¶Î§¿ÉÒÔͨ¹ýMºÍDµÄÑ¡Ôñ±»ÏÞÖÆ¡£Èç¹ûD±»Ê¡ÂÔ£¬Ëü±»ÉèÖÃΪ0¡£Èç¹ûM±»Ê¡µô£¬Ëü±»ÉèÖÃΪ10¡£ÔÚMysql3.22À


Ïà¹ØÎĵµ£º

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 ......

ubuntu°²×°MySQL£¬Apache

 °²裝MySQL-Server
$ sudo apt-get install mysql-server
°²裝Apache HTTP Server
$ sudo apt-get install apache2
°²裝PHP for Apache HTTP Server
$ sudo apt-get install php5
°²裝MySQL for Apache HTTP Server
$ sudo apt-get install libapache2-mod-auth-mysql
$ sudo apt-get ......

¿ÉÁ¯µÄSun¹«Ë¾£¬ÒòΪÊÕ¹ºÁËMySQL£¬ÏëÂô×Ô¼º¶¼Âô²»ÁËÁË

write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂë¶¼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......

ͨ¹ý·ÖÇø£¨Partition£©ÌáÉýMySQLÐÔÄÜ

°³½ñÌìÕâô¼¤¶¯ÓÖÏëдÎÄÕµÄÔ­ÒòÊÇMySQL5.1µÄ·¢²¼´øÀ´ÁËÉè¼Æ³¬Ç¿¶¯Á¦Êý¾Ý¿âµÄÇ¿ÓÐÁ¦µÄÎäÆ÷£¬ÈκÎMySQLµÄDBA¶¼Ó¦¸Ã¾¡¿ìѧϰ²¢Ê¹ÓÃËü¡£°³¾õµÃÈç¹ûÄܺܺõÎʹÓÃÕâ¸ö5.1°æ´øÀ´µÄÐÂÌØÐÔ£¬DBA¿ÉÒÔʹ×Ô¼º¹ÜÀíµÄVLDB£¨²»ÖªµÀʲôÊÇVLDB£¿¸æËßÄ㣬ÊǺôóºÃ´óµÄÊý¾Ý¿âµÄÒâ˼£¬Very Large DB£©»òÊý¾Ý²Ö¿âÆæ¼£°ãµÄ»ñµÃ¾Þ´óµÄÐÔÄÜÌáÉý¡£ ......

½â¾öÈçºÎÐÞ¸Ämysql·þÎñÆ÷¼àÌý¶Ë¿ÚµÄÎÊÌâ

 1£©Èç¹ûÄã°²×°µÄÊÇϵͳ×Ô´øµÄrpm°üµÄÇé¿ö£º
ÐÞ¸Ä /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
port=3300                    #Ð޸ijÉÄã×Ô¼ºÏëÒªµÄ¶Ë¿Ú
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_m ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ