MysqlÊý¾ÝÀàÐÍ
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡£
ÀàÐÍ
´óС
·¶Î§£¨ÓзûºÅ£©
·¶Î§£¨ÎÞ·ûºÅ£©
ÓÃ;
TINYINT
1 ×Ö½Ú
(-128£¬127)
(0£¬255)
СÕûÊýÖµ
SMALLINT
2 ×Ö½Ú
(-32 768£¬32 767)
(0£¬65 535)
´óÕûÊýÖµ
MEDIUMINT
3 ×Ö½Ú
(-8 388 608£¬8 388 607)
(0£¬16 777 215)
´óÕûÊýÖµ
INT»òINTEGER
4 ×Ö½Ú
(-2 147 483 648£¬2 147 483 647)
(0£¬4 294 967 295)
´óÕûÊýÖµ
BIGINT
8 ×Ö½Ú
(-9 233 372 036 854 775 808£¬9 223 372 036 854
775 807)
(0£¬18 446 744 073 709 551 615)
¼«´óÕûÊýÖµ
FLOAT
4 ×Ö½Ú
(-3.402 823 466 E+38£¬1.175 494 351
E-38)£¬0£¬(1.175 494 351 E-38£¬3.402 823 466 351 E+38)
0£¬(1.175 494 351 E-38£¬3.402 823 466 E+38)
µ¥¾«¶È
¸¡µãÊýÖµ
DOUBLE
8 ×Ö½Ú
(1.797 693 134 862 315 7 E+308£¬2.225 073 858 507
201 4 E-308)£¬0£¬(2.225 073 858 507 201 4 E-308£¬1.797 693 134 862
315 7 E+308)
0£¬(2.225 073 858 507 201 4 E-308£¬1.797 693 134
862 315 7 E+308)
Ë«¾«¶È
¸¡µãÊýÖµ
DECIMAL
¶ÔDECIMAL(M,D) £¬Èç¹ûM>D£¬ÎªM+2·ñÔòΪD+2
ÒÀÀµÓÚMºÍDµÄÖµ
ÒÀÀµÓÚMºÍDµÄÖµ
СÊýÖµ
INT ÀàÐÍ
¡¡¡¡ÔÚ MySQL ÖÐÖ§³ÖµÄ 5 ¸öÖ÷ÒªÕûÊýÀàÐÍÊÇ
TINYINT£¬SMALLINT£¬MEDIUMINT£¬INT ºÍ
BIGINT¡£ÕâЩÀàÐÍÔںܴó³Ì¶ÈÉÏÊÇÏàͬµÄ£¬Ö»ÓÐËüÃÇ´æ´¢µÄÖµµÄ´óСÊDz»ÏàͬµÄ¡£
¡¡¡¡MySQL ÒÔÒ»¸ö¿ÉÑ¡µÄÏÔʾ¿í¶ÈָʾÆ÷µÄÐÎʽ¶Ô SQL
±ê×¼½øÐÐÀ©Õ¹£¬ÕâÑùµ±´ÓÊý¾Ý¿â¼ìË÷Ò»¸öֵʱ£¬¿ÉÒÔ°ÑÕâ¸öÖµ¼Ó³¤µ½Ö¸¶¨µÄ³¤¶È¡£ÀýÈ磬ָ¶¨Ò»¸ö×ֶεÄÀàÐÍΪ
INT(6)£¬¾Í¿ÉÒÔ±£Ö¤Ëù°üº¬Êý×ÖÉÙÓÚ 6
¸öµÄÖµ´ÓÊý¾Ý¿âÖмìË÷³öÀ´Ê±Äܹ»×Ô¶¯µØÓÿոñÌî³ä¡£ÐèҪעÒâµÄÊÇ£¬Ê¹ÓÃÒ»¸ö¿í¶ÈָʾÆ÷²»»áÓ°Ïì×ֶεĴóСºÍËü¿ÉÒÔ´æ´¢µÄÖµµÄ·¶Î§¡£
¡¡¡¡ÍòÒ»ÎÒÃÇÐèÒª¶ÔÒ»¸ö×ֶδ洢һ¸ö³¬³öÐí¿É·¶Î§µÄÊý×Ö£¬MySQL
»á¸ù¾ÝÔÊÐí·¶Î§×î½Ó½üËüµÄÒ»¶Ë½Ø¶ÌºóÔÙ½øÐд洢¡£»¹ÓÐÒ»¸ö±È½ÏÌØ±ðµÄµØ·½ÊÇ£¬MySQL
»áÔÚ²»ºÏ¹æ¶¨µÄÖµ²åÈë±íǰ×Ô¶¯ÐÞ¸ÄΪ 0¡£
¡¡¡¡UNSIGNED
ÐÞÊηû¹æ¶¨×Ö¶ÎÖ»±£´æÕýÖµ¡£ÒòΪ²»ÐèÒª±£´æÊý×ÖµÄÕý¡¢¸º·ûºÅ£¬¿ÉÒÔÔÚ´¢Ê±½ÚÔ¼Ò»¸ö“λ”µÄ
Ïà¹ØÎĵµ£º
mysqladmin extended (¾ø¶ÔÖµ)
ÖØµãÈ¥¼àÊÓµÄÖµÓУº
* Slave_running:Èç¹ûϵͳÓÐÒ»¸ö´Ó¸´ÖÆ·þÎñÆ÷£¬Õâ¸öÖµÖ¸Ã÷ÁË´Ó·þÎñÆ÷µÄ½¡¿µ¶È
* Threads_connected:µ±Ç°¿Í»§¶ËÒÑÁ¬½ÓµÄÊýÁ¿¡£Õâ¸öÖµ»áÉÙÓÚÔ¤ÉèµÄÖµ£¬µ«ÄãÒ²ÄܼàÊÓµ½Õâ¸öÖµ½Ï´ó£¬Õâ¿É±£Ö¤¿Í»§¶ËÊÇ´¦ÔÚ»îԾ״̬¡£
* Threads_running:Èç¹ûÊý¾Ý¿â³¬¸ººÉÁË£¬Ä㽫»áµÃµ½Ò»¸ö ......
µ±Ç°»îÔ¾µÄÊÂÎñ:
------------
TRANSACTIONS
------------
Trx id counter080157601
Purge done for trx's n:o <0 80154573 undo n:o <0 0
History list length 6
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, proce ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......
MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GRO ......