Mysql limitÓ÷¨
1.SELECT
*
from
table
LIMIT
1
,
20
;
//
¼ìË÷¼Ç¼ÐÐ
2-21
µÚÒ»¸ö²ÎÊý£º²éѯÆðʼÐУ¨´Ó0¿ªÊ¼£©
µÚ¶þ¸ö²ÎÊý£º²éѯ¼¸Ìõ¼Ç¼
2.
SELECT
*
from
table
LIMIT
5
,
-
1
;
//
¼ìË÷¼Ç¼ÐÐ
6
-
last.
3.
SELECT
*
from
table
LIMIT
5
;
//
¼ìË÷ǰ
5
¸ö¼Ç¼ÐÐ
Ïà¹ØÎĵµ£º
ʹÓÃmysqlʱ£¬Í¨³£±íÖлáÓÐÒ»¸ö×ÔÔöµÄid×ֶΣ¬µ«µ±ÎÒÃÇÏ뽫±íÖеÄÊý¾ÝÇå¿ÕÖØÐÂÌí¼ÓÊý¾Ýʱ£¬Ï£ÍûidÖØÐ´Ó1¿ªÊ¼¼ÆÊý£¬ÓÃÒÔÏÂÁ½ÖÖ·½·¨¾ù¿É£º
·½·¨Ò»£º
alter table tablename drop column id;
alter table tablename add id mediumint(8) not null primary key auto_increment first;
·½·¨¶þ£º
alter table tab ......
require() Óë require_once()
ͨ³£·ÅÔÚ PHP ³ÌÐòµÄ×îÇ°Ãæ£¬PHP ³ÌÐòÔÚÖ´ÐÐǰ£¬¾Í»áÏȶÁÈë require
ËùÖ¸¶¨ÒýÈëµÄÎļþ£¬Èç¹û³öÏÖ´íÎóÊÇÖÂÃüµÄ¡£
nclude() Óë include_once()
&n ......
µØÖ·£º http://imysql.cn/taxonomy/term/1?page=1
[InnoDBϵÁÐ] -- innodb±íÈçºÎ¸ü¿ìµÃµ½count(*)½á¹û£ºhttp://imysql.cn/2008_06_24_speedup_innodb_count
[InnoDBϵÁÐϵÁÐ] -- ´óÊý¾ÝÁ¿µÄµ¼³öµ¼Èë·½·¨±È½Ï£º
http://imysql.cn/2007_10_15_large_innodb_table_export_import
[MySQLÓÅ»¯°¸Àý]ϵÁÐ -- DISABLE/ENABLE K ......
1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......