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

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ÁË¡£


Ïà¹ØÎĵµ£º

Òì¹¹Êý¾Ý¿âÊý¾Ýͬ²½(´ÓProgressµ½MySQL)

Ò»Ö±Ïëдµã¶«Î÷£¬µ«È´³Ù³ÙûÓпªÊ¼£¬½ñÌìÎÞÒâÖлص½ERP100Õâ¸öÍøÕ¾£¬·¢ÏÖÓÐÁËQADµÄרÇø£¬ÓÚÊÇ£¬Ò»Ê±ÈÈѪ·ÐÌÚ£¬Ð´Á˵㶫Î÷£¬¾Í½è´Ë»ú»á½«ÄÚÈÝÒ²·¢µ½ÕâÀï°É£¬ºÇºÇ¡£
ÆäʵÄÚÈݶ¼ÊDZ¾ÈËдµÄ£¬²»¹ýΪÁËͼ·½±ã£¬ÔÚERP100ÖÐдÍêÁË£¬È»ºóÖ±½ÓCopyµ½ÕâÀ͵Á˵ãÀÁ£¬ºÇºÇ¡£
ÒÔÏÂÊÇÕýÎÄ£¬ÔÚERP100ÖеĵØÖ·ÊÇ
http://bbs.erp100.com ......

Mysql´íÎ󼯽õ£¨Linux£©


 
1£º Can’t connect to [local] MySQL server´íÎó
Ò»¸öMySQL¿Í»§¿ÉÒÔÁ½ÖÖ²»Í¬µÄ·½Ê½Á¬½Ómysqld·þÎñÆ÷£ºUnixÌ×½Ó×Ö£¬Ëüͨ¹ýÔÚÎļþϵͳÖеÄÒ»¸öÎļþ(ȱʡ“/tmp /mysqld.sock”)½øÐÐÁ¬½Ó£»»òTCP/IP£¬Ëüͨ¹ýÒ»¸ö¶Ë¿ÚºÅÁ¬½Ó¡£UnixÌ×½Ó×Ö±ÈTCP/IP¸ü¿ì£¬µ«ÊÇÖ»ÓÐÓÃÔÚÁ¬½Óͬһ̨¼ÆËã»úÉϵķþÎñÆ÷¡£Èç¹ûÄ ......

mysqlµ÷Óúó

ÓÃmysql_query£¬mysql_fetch_array()ºóÓ¦¸ÃÒª
free_result().function count_admin($where = '')
{
if($where) $where = " WHERE $where";
$result = $this->db->get_one("SELECT count(*) as num from $this->table_admin_role $where");
return $result['num'];
} ......

mysqlµ¼Èëµ¼³öÊý¾Ý¿â

¼¸¸ö³£ÓÃÓÃÀý£º
1.µ¼³öÕû¸öÊý¾Ý¿â mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû     mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql2.µ¼³öÒ»¸ö±í mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql3.µ¼³öÒ»¸öÊý¾Ý¿â½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ