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

MysqlÖÐlimitµÄÓ÷¨Ïê½â


MysqlÖÐlimitµÄÓ÷¨£ºÔÚÎÒÃÇʹÓòéѯÓï¾äµÄʱºò£¬¾­³£Òª·µ»ØÇ°¼¸Ìõ»òÕßÖмäij¼¸ÐÐÊý¾Ý£¬Õâ¸öʱºòÔõô°ìÄØ£¿²»Óõ£ÐÄ£¬mysqlÒѾ­ÎªÎÒÃÇÌṩÁËÕâÑùÒ»¸ö¹¦ÄÜ¡£
SELECT * from table   LIMIT [offset,] rows | rows OFFSET offset
LIMIT ×Ó¾ä¿ÉÒÔ±»ÓÃÓÚÇ¿ÖÆ SELECT Óï¾ä·µ»ØÖ¸¶¨µÄ¼Ç¼Êý¡£LIMIT ½ÓÊÜÒ»¸ö»òÁ½¸öÊý×Ö²ÎÊý¡£²ÎÊý±ØÐëÊÇÒ»¸öÕûÊý³£Á¿¡£Èç¹û¸ø¶¨Á½¸ö²ÎÊý£¬µÚÒ»¸ö²ÎÊýÖ¸¶¨µÚÒ»¸ö·µ»Ø¼Ç¼ÐÐµÄÆ«ÒÆÁ¿£¬µÚ¶þ¸ö²ÎÊýÖ¸¶¨·µ»Ø¼Ç¼ÐеÄ×î´óÊýÄ¿¡£³õʼ¼Ç¼ÐÐµÄÆ«ÒÆÁ¿ÊÇ 0(¶ø²»ÊÇ 1)£º ΪÁËÓë PostgreSQL ¼æÈÝ£¬MySQL Ò²Ö§³Ö¾ä·¨£º LIMIT # OFFSET #¡£
mysql> SELECT * from table LIMIT 5,10; // ¼ìË÷¼Ç¼ÐÐ 6-15
//ΪÁ˼ìË÷´Óijһ¸öÆ«ÒÆÁ¿µ½¼Ç¼¼¯µÄ½áÊøËùÓеļǼÐУ¬¿ÉÒÔÖ¸¶¨µÚ¶þ¸ö²ÎÊýΪ -1£º
mysql> SELECT * from table LIMIT 95,-1; // ¼ìË÷¼Ç¼ÐÐ 96-last.
//Èç¹ûÖ»¸ø¶¨Ò»¸ö²ÎÊý£¬Ëü±íʾ·µ»Ø×î´óµÄ¼Ç¼ÐÐÊýÄ¿£º
mysql> SELECT * from table LIMIT 5;     //¼ìË÷ǰ 5 ¸ö¼Ç¼ÐÐ
//»»¾ä»°Ëµ£¬LIMIT n µÈ¼ÛÓÚ LIMIT 0,n¡£
×¢Òâlimit 10ºÍlimit 9£¬1µÄ²»Í¬£º
ÀýÈ磺
1.
Select * from cyclopedia Where ID>=(
Select Max(ID) from (
Select ID from cyclopedia Order By ID limit 90001
) As tmp
) limit 100;
2.
Select * from cyclopedia Where ID>=(
Select Max(ID) from (
Select ID from cyclopedia Order By ID limit 90000,1
) As tmp
) limit 100;
ͬÑùÊÇÈ¡90000Ìõºó100Ìõ¼Ç¼,µÚ1¾ä¿ì»¹ÊǵÚ2¾ä¿ì?
µÚ1¾äÊÇÏÈÈ¡ÁËǰ90001Ìõ¼Ç¼,È¡ÆäÖÐ×î´óÒ»¸öIDÖµ×÷ΪÆðʼ±êʶ,È»ºóÀûÓÃËü¿ÉÒÔ¿ìËÙ¶¨Î»ÏÂ100Ìõ¼Ç¼
µÚ2¾äÔñÊǽö½öÈ¡90000Ìõ¼Ç¼ºó1Ìõ,È»ºóÈ¡IDÖµ×÷Æðʼ±êʶ¶¨Î»ÏÂ100Ìõ¼Ç¼
µÚ1¾äÖ´Ðнá¹û.100 rows in set (0.23) sec
µÚ2¾äÖ´Ðнá¹û.100 rows in set (0.19) sec
ÆäʵµÚ2¾äÍêÈ«¿ÉÒÔ¼ò»¯³É£º
Select * from cyclopedia Where ID>=(
Select ID from cyclopedia limit 90000,1
)limit 100;
Ö±½ÓÀûÓõÚ90000Ìõ¼Ç¼µÄID,²»Óþ­¹ýMaxÔËËã,ÕâÑù×öÀíÂÛÉÏЧÂÊÒò¸Ã¸ßһЩ,µ«ÔÚʵ¼ÊʹÓÃÖм¸ºõ¿´²»µ½Ð§¹û,ÒòΪ±¾Éí¶¨Î»ID·µ»ØµÄ¾ÍÊÇ1Ìõ¼Ç¼,Max¼¸ºõ²»ÓÃÔË×÷¾ÍÄܵõ½½á¹û,µ«ÕâÑùд¸üÇåäÀÃ÷ÀÊ,ʡȥÁË»­ÉßÄÇÒ»×ã.
Select Top 100 * from cyclopedia Where ID>=(
Select Top 90001 Max(ID) from (
Select ID from cyclopedia Order By ID
) As tmp
)
µ«²»¹ÜÊÇʵÏÖ·½


Ïà¹ØÎĵµ£º

ÈçºÎ²é¿´mysqlÔËÐС¢·ÃÎʼǼµÈÈÕÖ¾


1.Ê×ÏÈÈ·ÈÏÄãÈÕÖ¾ÊÇ·ñÆôÓÃÁË
mysql>show variables like 'log_bin';
mysql>show variables like 'log';
2.Èç¹ûÆôÓÃÁË£¬¼´ON
Èç¹ûûÓÐÆôÓ㬼´OFF£¬
ÒªÐÞ¸Ämy.cnf
  
  #   The   MySQL   server   
  [mysqld]   
    
  # ......

mysqlÈÕÖ¾

http://hi.baidu.com/ubuntu2me/blog/item/e1bd54de9a428f1862279828.html
¡¾IT168¼¼ÊõÎĵµ
¡¿ÈκÎÒ»ÖÖÊý¾Ý¿âÖУ¬¶¼Óи÷ÖÖ¸÷ÑùµÄÈÕÖ¾¡£MysqlÒ²²»ÀýÍ⣬ÔÚMysqlÖÐÓÐ4ÖÖ²»Í¬µÄÈÕÖ¾¡¢·Ö±ð´íÎóÈÕÖ¾¡¢¶þ½øÖÆÈÕÖ¾¡¢²éѯÈÕÖ¾ºÍÂý²éѯÈÕÖ¾¡£ÕâЩÈÕÖ¾¼Ç¼×ÅMysqlÊý¾Ý¿â²»Í¬·½ÃæµÄ×Ù¼£¡£ÏÂÎĽ«½éÉÜÕâ4ÖÖ²»Í¬µÄÈÕÖ¾×÷ÓúÍÓÃ;¡£
¡¡¡ ......

mysql ʱ¼äµÄ´¦Àí

TO_DAYS(date)   //¸ø¶¨Ò»¸öÈÕÆÚ£¬·µ»Ø´Ó0Ä꿪ʼµÄÌìÊý¡£
from_DAYS(N)   //¸ø¶¨Ò»¸öÌìÊý£¬·µ»ØÒ»¸öÈÕÆÚ¡£
È磺
select TO_DAYS('1997-10-7')   //·µ»Ø729669
select from_DAYS(729669)    //·µ»Ø1997-10-7
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)
ÈôÎÞ²ÎÊýµ÷Óã¬Ôò·µ ......

MySql Êý¾ÝÀàÐÍ´óÈ«

MySQLÖ§³Ö´óÁ¿µÄÁÐÀàÐÍ£¬Ëü¿ÉÒÔ±»·ÖΪ3ÀࣺÊý×ÖÀàÐÍ¡¢ÈÕÆÚºÍʱ¼äÀàÐÍÒÔ¼°×Ö·û´®(×Ö·û)ÀàÐÍ¡£±¾½ÚÊ×Ïȸø³ö¿ÉÓÃÀàÐ͵ÄÒ»¸ö¸ÅÊö£¬²¢ÇÒ×ܽáÿ¸öÁÐÀàÐ͵Ĵ洢ÐèÇó£¬È»ºóÌṩÿ¸öÀàÖеÄÀàÐÍÐÔÖʵĸüÏêϸµÄÃèÊö¡£¸ÅÊöÓÐÒâ¼ò»¯£¬¸üÏêϸµÄ˵Ã÷Ó¦¸Ã¿¼Âǵ½ÓйØÌض¨ÁÐÀàÐ͵ĸ½¼ÓÐÅÏ¢£¬ÀýÈçÄãÄÜΪÆäÖ¸¶¨ÖµµÄÔÊÐí¸ñʽ¡£
ÓÉMySQLÖ§³ÖµÄÁÐ ......

ÓÃADO²Ù×÷MYSQLÊý¾Ý¿â

ÓÃADO²Ù×÷MYSQLÊý¾Ý¿â VBEÖÐÇëÈ·¶¨ÒýÓà microsoft activeX data objects xx ¿âÁ¬½Ó¼°¸üÐÂMYSQLÊý¾Ý¿âÊý¾Ý
´úÂëÈçÏÂ: Sub updt() Dim strconnt As String strconnt = "" Set connt = New ADODB.Connection Dim sevip, Db, user, pwd As String 'Éè·þÎñÆ÷µØÖ·¡¢ËùÁ¬Êý¾Ý£¬¼°µÇ¼Óû§ÃÜÂë sevip = "localhost" '"192.168.*.* ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ