mysqlÖÐint¡¢bigint¡¢smallint ºÍ tinyintµÄÇø±ð
ʹÓÃÕûÊýÊý¾ÝµÄ¾«È·Êý×ÖÊý¾ÝÀàÐÍ¡£
bigint
´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
int
´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£
smallint
´Ó -2^15 (-32,768) µ½ 2^15 - 1 (32,767) µÄÕûÐÍÊý¾Ý¡£´æ´¢´óСΪ 2 ¸ö×Ö½Ú¡£
tinyint
´Ó 0 µ½ 255 µÄÕûÐÍÊý¾Ý¡£´æ´¢´óСΪ 1 ×Ö½Ú¡£
×¢ÊÍ
ÔÚÖ§³ÖÕûÊýÖµµÄµØ·½Ö§³Ö bigint Êý¾ÝÀàÐÍ¡£µ«ÊÇ£¬bigint ÓÃÓÚijЩÌØÊâµÄÇé¿ö£¬µ±ÕûÊýÖµ³¬¹ý int Êý¾ÝÀàÐÍÖ§³ÖµÄ·¶Î§Ê±£¬¾Í¿ÉÒÔ²ÉÓà bigint¡£ÔÚ SQL Server ÖУ¬int Êý¾ÝÀàÐÍÊÇÖ÷ÒªµÄÕûÊýÊý¾ÝÀàÐÍ¡£
ÔÚÊý¾ÝÀàÐÍÓÅÏÈ´ÎÐò±íÖУ¬bigint λÓÚ smallmoney ºÍ int Ö®¼ä¡£
Ö»Óе±²ÎÊý±í´ïʽÊÇ bigint Êý¾ÝÀàÐÍʱ£¬º¯Êý²Å·µ»Ø bigint¡£SQL Server ²»»á×Ô¶¯½«ÆäËüÕûÊýÊý¾ÝÀàÐÍ£¨tinyint¡¢smallint ºÍ int£©ÌáÉýΪ bigint¡£
Ïà¹ØÎĵµ£º
ʹÓÃÄÚ²¿º¯Êýinstr£¬¿É´úÌ洫ͳµÄlike·½Ê½²éѯ£¬²¢ÇÒËٶȸü¿ì¡£
instrº¯Êý£¬µÚÒ»¸ö²ÎÊýÊÇ×ֶΣ¬µÚ¶þ¸ö²ÎÊýÊÇÒª²éѯµÄ´®£¬·µ»Ø´®µÄλÖ㬵ÚÒ»¸öÊÇ1£¬Èç¹ûûÕÒµ½¾ÍÊÇ0.
ÀýÈ磬
select name from tpl_user where 1 and instr(`name`,’jack’);
¿É²éѯÃû×ÖÖдøjackµÄÃû×Ö¡£ ......
±¾ÎÄתÔØ×Ô£ºhttp://www.54xue.com/?action-viewnews-itemid-7498
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, ֻʹÓÃInnoDB, ACID, ÉÙÁ¿µÄÁ¬½Ó, ¶ÓÁиºÔØ´ó
#TYPE: SYSTEM
#END CONFIG INFO
#
# ´ËmysqlÅäÖÃÎļþÀý×ÓÕë¶Ô4GÄÚ´æ
# Ö÷ҪʹÓÃINNODB
#´¦Àí¸´ÔÓ¶ÓÁв¢ÇÒÁ¬½ÓÊýÁ¿½ÏÉÙµÄmysql·þÎñÆ÷
#
# ½«´ËÎļþ¸´ÖƵ½/etc/m ......
Èç¹ûÒªËæ»ú»ñÈ¡¼Ç¼Êý£¬ÔÚmysqlÀï×î¼òµ¥µÄ·½·¨¿Ï¶¨ÊÇorder
by
rand
()ÁË£¬µ«ÊÇÕâÖÖ·½·¨Ö»ÄÜÔÚ±í¼Ç¼¼«ÉÙµÄÇé¿öϲÅÄÜʹÓá£Ö÷ÒªÊÇÒòΪorder
by
rand
()µ¼ÖÂÁËusing filesort.Õâ¸öʱºò²éѯÀàÐÍ»á±ä³Éall£¬Ë÷Òý»áʧЧ¡£Ö»Ðè¼òµ¥µÄ±äͨÏ£¬Íê³É¿ÉÒÔ×öµ½Í¬ÑùµÄЧ¹û¡£
¸ù¾Ý¼Ç¼µÄÀàÐÍ£¬·ÖÀàÁ¬ÐøºÍ·ÇÁ¬ÐøÁ½ÖÖ¡£
Á¬ÐøÖ ......
MySQL£ºÈÕÆÚº¯Êý¡¢Ê±¼äº¯Êý×ܽᣨMySQL 5.X£©
²Î¿¼³¤ÎÄ£º
Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2008-08-08 22:20:46 |
+---------------------+
³ýÁË now() º¯ÊýÄÜ»ñµÃµ±Ç°µ ......
Î塢ʼþµ÷¶ÈÆ÷²âÊÔ
5.1¡¢²âÊÔÄ¿µÄ
5.1.1 ÅäÖ÷½·¨
5.1.2 ÊÇ·ñÕý³£¹¤×÷
5.1.3 ÈÕ³£µÄά»¤
5.2¡¢Ê¼þµ÷¶ÈÆ÷½éÉÜ
×ÔMySQL5.1.6Æð£¬Ôö¼ÓÁËÒ»¸ö·Ç³£ÓÐÌØÉ«µÄ¹¦ÄÜ
–ʼþµ÷¶ÈÆ÷(Event Scheduler)£¬¿ÉÒÔÓÃ×ö¶¨Ê±Ö´ÐÐijЩÌض¨ÈÎÎñ£¨ÀýÈ磺ɾ³ý
¼Ç¼¡¢¶ÔÊý¾Ý
½øÐлã×ܵȵȣ©£¬À´È¡´ ......