MySql**ÀàÐÍÓÐÄÄЩ

MysqlÖ§³ÖµÄ¶àÖÖ**ÀàÐÍÖ÷ÒªÓУºÊýÊÂÓëÅàÏë·òÕÔ¼ÆÖµ**ÀàÐÍ¡¢ÈÕÆÚ/À´×Ôʱ¼äÀàÐÍ¡¢×Ö·û´®ÀàÐÍ¡£

1.ÕûÊý**ÀàÐͼ°ÆäÈ¡Öµ·¶Î§£º

ÀàÐÍ

˵Ã÷

´æ´¢ÐèÇó£¨È¡Öµ·¶Î§£©

tinyintºÜСÕûÊý1×Ö½Ú£¨[0~255]¡¢[-128~127]£©;255=2^8-1;127=2^7-1

**allintСÎÊ´ðÕûÊý2×Ö½Ú£¨0~65535¡¢-32768~32767£©;65535=2^16-1

mediumintÖжÊÔöºÎ¹ÌÆó´©ÀúÇøÕ÷ÖµÈ3×Ö½Ú£¨0~16777215£©;16777215=2^24-1

int(integer)ÆÕͨ4×Ö½Ú£¨0~4294967295£©;4294967295=2^32-1

bigint´óÕûÊý8×Ö½Ú£¨0~18446744073709551615£©;184467440737Å©¶î¸ãÇ°Ïà09551615=2^64-1

¸¡µãÊý&¶¨µãÊý£º

ÀàÐÍÃû³Æ

˵Ã÷

´æ´¢ÐèÇó

floatµ¥¾«¶È¸¡µãÊý4×Ö½Ú

doubleË«ÀͲÅËÕ»áÖݾ«¶È¸¡µãÊý8×Ö½Ú

decimalѹËõµÄ¡°Ñϸñ¡±¶¨µãÊýM+2×Ö½Ú

×¢£º¶¨µãÊýÒÔ×Ö·û´®ÐÎʽ´æ´¢£¬¶Ô¾«¶ÈÒªÇó¸ßʱʹ¶àÓÃdecimal½ÏºÃ£»¾¡Á¿·ò¸è¶Ï»µÓÖ×÷±ÜÃâ¶Ô¸¡µãÊý½øÐмõ·¨ºÍ±È½ÏÔËËã¡£
2.ʱ¼ä/ÈÕÆÚÀàÐÍ£º
year·¶Î§£º1901~215Ëä´º¹©ÐǵÍÊô5;
time¸ñʽ£º¡®¹»±ð¿Í¹ã±£¼¯h**h**:MM:SS¡¯£¨Èç¹ûÊ¡ÂÔд£¬²¢ÇÒûÓÐðºÅ£¬ÔòĬÈÏ×îÓÒÆð2λΪÃ룬ÔÙµ½·Ö£¬×îºóµ½Ê±£©£»
²åÈëϵͳµ±Ç°Ê±¼ä£ºinsertinto±íÃûvalu¼¼Ê÷es(current_datÅ®ÂÉ×ãÔØÈÝЦµØ¶ËÑÔe()),(now());
d¸½ÂÉҪͬƵÎö¶À»îateÀàÐÍ£º¡®YYYY-MM-DD¡¯£»
datetime£¨ÈÕÆÚ+ʱ¼ä£©£º¡®YYYY-MM-DDh**h**:MM:SS¡¯»ò¡®YYYYMMDDh**h**MMSS¡¯£¬È¡Öµ·¶Î§£º¡®1000-01-0100:00:00¡¯~¡®9999-12-3123λÖøºò½Ú:59:59¡¯£»
timestamp¸ñʽͬdatetime£¬µ«Ôڴ洢ʱÐèÒª4¸ö×Ö½Ú(dÀúÁ˾«Åä·¹ÎåatetimeÐèÒª8×Ö½Ú)£¬²¢ÇÒÒÔUTC£¨ÊÀ½ç±ê׼ʱ¼ä£©½øÐд洢£¨¼´timestamp»áËæÉèÖõÄʱÇø¶ø±ä»¯£¬¶ødatetime´æ´¢µ±ÓàѹºË°¢Õù¿îÁÙÉË´óµÄ¾ø²»»á±ä»¯£©£»timestampµÄ·¶Î§£º1970-2037¡£

3.×Ö·û´®ÀàÐÍ£º
textÀàÐÍ£ºtinytext¡¢text¡¢mediumte³¯xt¡¢longtext;

ÀàÐÍ

·¶Î§

tinytext25ÑóÇ¿»¯Î¶±ê½µÎå·¶¶þ5=2^8-1

text65535=2^16-1

me×ÔÉϿؾäÖÊdiumtext16777215=2^24-1

longtext4Õòµô¾ÍÖ®ºñ¼¸ÖÂÊö´ø294967295=4GB=2^32-1

charµÄ´æ´¢ÐèÇóÊǶ¨Òåʱָ¶¨µÄ¹Ì¶¨³¤¶È£»varcharµÄ´æ´¢ÐèÇóÊÇÈ¡¾öÓÚʵ¼ÊÖ**¤¶È¡£
setÀàÐ͸ñʽ£ºset£¨¡¯Öµ1¡¯,¡¯Öµ2¡¯¡­)¡ª¡ª¿ÉÒÔÓÐ0»òÕ߶à¸öÖµ£¬¶ÔÓÚset¶øÑÔ£¬Èô²åÈëµÄֵΪÖظ´µÄ£¬ÔòֻȢһ¸ö¡£²åÈëµÄÖµÂÒÐò£¬Ôò×Ô¶¯°´Ë³Ðò²åÈëÅÅÁС£²åÈë²»Õý³£Öµ£¬ÔòºöÂÔ¡£
¶þ½øÖÆÀàÐÍ£º
bit£¨M£©¡ª¡ª±£´æλ×Ö¶ÎÖµ£¨Î»×Ö¶ÎÀàÐÍ£©£¬M±íʾֵµÄλÊý£»
eg:selectBIN(b+0)from±íÃû£»¡ª¨CbΪÁÐÃû;b+0±íʾ½«¶þ½øÖƵĽá¹ûת»»Îª¶ÔÓ¦µÄÊý×ÖµÄÖµ£¬BIN£¨£©º¯Êý½«Êý×Öת»»Îª¶þ½øÖÆ¡£

blog¡ª¡ª-¶þ½øÖÆ´ó¶ÔÏó£¬ÓÃÀ´´æ´¢¿É±äÊýÁ¿µÄ**¡£

**ÀàÐÍ

´æ´¢·¶Î§(×Ö½Ú)

tinyblog×î¶à255=2^8-1×Ö½Ú

bolg×î¶à65535=2^16-1×Ö½Ú

mediumblog×î¶à16777215=2^24-1×Ö½Ú

longblog×î¶à4294967295=4GB=2^32-1×Ö½Ú