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ÁË¡£
Ïà¹ØÎĵµ£º
Ò»Ö±Ïëдµã¶«Î÷£¬µ«È´³Ù³ÙûÓпªÊ¼£¬½ñÌìÎÞÒâÖлص½ERP100Õâ¸öÍøÕ¾£¬·¢ÏÖÓÐÁËQADµÄרÇø£¬ÓÚÊÇ£¬Ò»Ê±ÈÈѪ·ÐÌÚ£¬Ð´Á˵㶫Î÷£¬¾Í½è´Ë»ú»á½«ÄÚÈÝÒ²·¢µ½ÕâÀï°É£¬ºÇºÇ¡£
ÆäʵÄÚÈݶ¼ÊDZ¾ÈËдµÄ£¬²»¹ýΪÁËͼ·½±ã£¬ÔÚERP100ÖÐдÍêÁË£¬È»ºóÖ±½ÓCopyµ½ÕâÀ͵Á˵ãÀÁ£¬ºÇºÇ¡£
ÒÔÏÂÊÇÕýÎÄ£¬ÔÚERP100ÖеĵØÖ·ÊÇ
http://bbs.erp100.com ......
1£º Can’t connect to [local] MySQL server´íÎó
Ò»¸öMySQL¿Í»§¿ÉÒÔÁ½ÖÖ²»Í¬µÄ·½Ê½Á¬½Ómysqld·þÎñÆ÷£ºUnixÌ×½Ó×Ö£¬Ëüͨ¹ýÔÚÎļþϵͳÖеÄÒ»¸öÎļþ(ȱʡ“/tmp /mysqld.sock”)½øÐÐÁ¬½Ó£»»òTCP/IP£¬Ëüͨ¹ýÒ»¸ö¶Ë¿ÚºÅÁ¬½Ó¡£UnixÌ×½Ó×Ö±ÈTCP/IP¸ü¿ì£¬µ«ÊÇÖ»ÓÐÓÃÔÚÁ¬½Óͬһ̨¼ÆËã»úÉϵķþÎñÆ÷¡£Èç¹ûÄ ......
ÓÃ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'];
} ......
¼¸¸ö³£ÓÃÓÃÀý£º
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.µ¼³öÒ»¸öÊý¾Ý¿â½ ......