mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµÄ¡£
ÍøÉÏÒ²ºÜ¶à¹ØÓÚlimitµÄÎåÌõÓÅ»¯×¼Ôò£¬¶¼ÊÇ·Òë×ÔmysqlÊֲᣬËäÈ»ÕýÈ·µ«²»ÊµÓ᣽ñÌì·¢ÏÖһƪÎÄÕÂдÁËЩ¹ØÓÚlimitÓÅ»¯µÄ£¬ºÜ²»´í¡£
ÎÄÖв»ÊÇÖ±½ÓʹÓÃlimit£¬¶øÊÇÊ×ÏÈ»ñÈ¡µ½offsetµÄidÈ»ºóÖ±½ÓʹÓÃlimit sizeÀ´»ñÈ¡Êý¾Ý¡£¸ù¾ÝËûµÄÊý¾Ý£¬Ã÷ÏÔÒªºÃÓÚÖ±½ÓʹÓÃlimit¡£ÕâÀïÎÒ¾ßÌåʹÓÃÊý¾Ý·ÖÁ½ÖÖÇé¿ö½øÐвâÊÔ¡££¨²âÊÔ»·¾³win2033+p4Ë«ºË (3GHZ) +4GÄÚ´æ mysql 5.0.19£©
1¡¢offset±È½ÏСµÄʱºò¡£
select * from yanxue8_visit limit 10,10
¶à´ÎÔËÐУ¬Ê±¼ä±£³ÖÔÚ0.0004-0.0005Ö®¼ä
Select * from yanxue8_visit Where vid £¾=(
Select vid from yanxue8_visit Order By vid limit 10,1
) limit 10
¶à´ÎÔËÐУ¬Ê±¼ä±£³ÖÔÚ0.0005-0.0006Ö®¼ä£¬Ö÷ÒªÊÇ0.0006
½áÂÛ£ºÆ«ÒÆoffset½ÏСµÄʱºò£¬Ö±½ÓʹÓÃlimit½ÏÓÅ¡£Õâ¸öÏÔÈ»ÊÇ×Ó²éѯµÄÔÒò¡£
2¡¢offset´óµÄʱºò¡£
select * from yanxue8_visit limit 10000,10
¶à´ÎÔËÐУ¬Ê±¼ä±£³ÖÔÚ0.0187×óÓÒ
Select * from yanxue8_visit Where vid £¾=(
Select vid from yanxue8_visit Order By vid limit 10000,1
) limit 10
¶à´ÎÔËÐУ¬Ê±¼ä±£³ÖÔÚ0.0061×óÓÒ£¬Ö»ÓÐÇ°ÕßµÄ1/3¡£¿ÉÒÔÔ¤¼ÆoffsetÔ½´ó£¬ºóÕßÔ½ÓÅ¡£
ÒÔºóҪעÒâ¸ÄÕý×Ô¼ºµÄlimitÓï¾ä£¬ÓÅ»¯Ò»ÏÂmysqlÁË¡£
Ïà¹ØÎĵµ£º
1¡¢ÏÂÔØMySQLµÄLinux°²×°Îļþ
¡¡¡¡LinuxÏ°²×°MySQLÐèÒªÏÂÃæÁ½¸öÎļþ£º
¡¡¡¡MySQL-server-5.1.7-0.i386.rpm
¡¡¡¡ÏÂÔصØַΪ£ºhttp://dev.mysql.com/downloads/mysql/5.1.html£¬´ò¿ª´ËÍøÒ³£¬ÏÂÀÍøÒ³ÕÒµ½“Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads”ÏÕÒµ½“Ser ......
ʾÀý£º
create procedure proc_name (in parameter integer)
begin
declare variable varchar(20);
if parameter=1 then
set variable='MySQL';
else
set variable='PHP';
end if;
insert into tb (name) values (variable);
end;
MySQLÀ©Õ¹Ò²ÊÇÖ§³Ö´æ´¢¹ý³ÌµÄ£¬²»¹ýÖ»Ö§³ÖÎÞ·µ»Ø½á¹ûµÄ´æ´¢¹ý³Ì
¿ÉÒÔÊ¹Ó ......
¹Ø¼ü´Ê£ºMySQL ±¸·Ý »Ö¸´
¡¡¡¡±¸·ÝÊÇ×î¼òµ¥µÄ±£»¤Êý¾ÝµÄ·½·¨£¬±¾½Ú½«½éÉܶàÖÖ±¸·Ý·½·¨¡£ÎªÁ˵õ½Ò»¸öÒ»Öµı¸·Ý£¬ÔÚÏà¹ØµÄ±íÉÏ×öÒ»¸öLOCK TABLES£¬ÄãÖ»ÐèÒ»¸ö¶ÁËø¶¨£¬µ±ÄãÔÚÊý¾Ý¿âĿ¼ÖÐ×öÎļþµÄÒ»¸ö¿½±´Ê±£¬ÕâÔÊÐíÆäËûÏ̼߳ÌÐø²éѯ¸Ã±í;µ±Äã»Ö¸´Êý¾Ýʱ£¬ÐèÒªÒ»¸öдËø¶¨£¬ÒÔ±ÜÃâ³åÍ»¡£
¡¡¡¡Ê¹ÓÃSQL ......
°²×°ÅäÖÃmysql
http://edu.codepub.com/2009/1213/18710.php
Ò»¡¢
ÏÂÔرàÒë°²×°
#cd /usr/local/src/
#wget http://mysql.byungsoo.net/Downloads/MySQL-5.1/mysql-5.1.38.tar.gz
#tar –xzvf mysql-5.1.38.tar.gz ../software/
#./configure
--prefix=/usr/local/mysql //MySQL°²×°Ä¿Â¼
--datadir=/mydata / ......
MySQLÃÜÂëÐ޸ķ½·¨
Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£
·½·¨Ò»
¡¡¡¡Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬
¡¡¡¡²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
¡¡¡¡·½·¨¶þ
¡¡ ......