MSSQL ʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
MSSQL ÈçºÎʵÏÖ MySQL µÄ limit ²éѯ·½Ê½
²»ÖªÎªºÎ£¬MSSQL ÖÐûÓÐ limit Õâ¸ö¼«ÎªÖØÒªµÄ²éѯ·½Ê½£¬ÊìϤ MySQL µÄÅóÓѶ¼ÖªµÀ£¬MySQL µÄ limit ¶ÔÓÚʵÏÖ·ÖÒ³ºÍһЩÏÞÖÆ½á¹û¼¯µÄÓ¦ÓÃÖзdz£·½±ã¡£Ã»Óв»Òª½ô£¬ÎÒÃÇ¿ÉÒÔÓÃÆäËû·½·¨´ïµ½Í¬ÑùµÄÄ¿µÄ£¬×Ô¼º¶¯ÊÖ£¬·áÒÂ×ãʳ£¡
Óï·¨£º
Code:
SELECT * from
(
SELECT TOP [ÿҳ¼Ç¼]
* from
(
SELECT TOP [ÿҳ¼Ç¼*µ±Ç°Ò³Êý]
[×Ö¶Î1, ×Ö¶Î2, ...]
from [Êý¾Ý±í]
ORDER BY [ÅÅÐò×Ö¶Î]
DESC
)
[±í±ðÃû1]
ORDER BY [ÅÅÐò×Ö¶Î]
)
[±í±ðÃû2]
ORDER BY [ÅÅÐò×Ö¶Î]
DESC
ʾÀý£º
Code:
SELECT * from
(
SELECT TOP 5 * from
(
SELECT TOP 10 *
from table
ORDER BY id DESC
) t1
ORDER BY id
) t2
ORDER BY id DESC
ÉÏÃæµÄ´úÂë±íʾ´Ó table ±íÖлñÈ¡¼Ç¼£¬Ã¿Ò³5Ìõ¼Ç¼£¬µ±Ç°ÊǵڶþÒ³5*2=10£¬½á¹û°´ÕÕ id µ¹ÐòÅÅÁС£
Ïà¹ØÎĵµ£º
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö²ÎÊý-h»úÆ÷IP
µ ......
Chapter 4. Indexes
Ë÷ÒýÓÐÖúÓÚMySQLÔÚºÆÈçÑ̺£µÄÊý¾ÝÖÐѸËÙÕÒµ½ºÍÈ¡µÃÕýÈ·µÄ¼Ç¼¡£
4.1 Indexing Basics
4.1.1 Index Concepts
Ë÷ÒýÊǰ´ÕÕijÖÖ¹æÔòÅÅÐòµÄ¡£Ë÷ÒýÒ²¾ÍÊÇÎþÉüһЩ¿Õ¼äºÍcpuµÄ¿ªÏúÀ´Ê¹ÄãµÄ²éѯÅܵøü¿ìµã¡£ÁíÍâÌáÐѵÄÊÇ£¬¶ÔÓÚMySQLÀ´½²£¬ÊõÓï“Key”ºÍ“Index”ÊÇ¿ÉÒÔ»¥ÏàÌæ»»µÄ¡£
4. ......
Ò»¡¢ÈÏʶË÷Òý
¡¡¡¡(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒà ......
ISAM
ISAMÊÇÒ»¸ö¶¨ÒåÃ÷È·ÇÒÀú¾Ê±¼ä¿¼ÑéµÄÊý¾Ý±í¸ñ¹ÜÀí·½·¨£¬ËüÔÚÉè¼ÆÖ®Ê±¾Í¿¼Âǵ½Êý¾Ý¿â±»²éѯµÄ´ÎÊýÒªÔ¶´óÓÚ¸üеĴÎÊý¡£Òò´Ë£¬ISAMÖ´ÐжÁÈ¡²Ù×÷µÄËٶȺܿ죬¶øÇÒ²»Õ¼ÓôóÁ¿µÄÄÚ´æºÍ´æ´¢×ÊÔ´¡£ISAMµÄÁ½¸öÖ÷Òª²»×ãÖ®´¦ÔÚÓÚ£¬Ëü²»Ö§³ÖÊÂÎñ´¦Àí£¬Ò²²»Äܹ»ÈÝ´í£ºÈç¹ûÄãµÄÓ²Å̱ÀÀ£ÁË£¬ÄÇôÊý¾ÝÎļþ¾ÍÎÞ·¨»Ö¸´ÁË¡£Èç¹ûÄãÕýÔÚ°Ñ ......
Ò»¡¢ ·ÖÇøµÄ¸ÅÄî
¶þ¡¢ ΪʲôʹÓ÷ÖÇø£¿£¨Óŵ㣩
Èý¡¢ ·ÖÇøÀàÐÍ
ËÄ¡¢ ×Ó·ÖÇø
Îå¡¢ ¶Ô·ÖÇø½øÐÐÐ޸ģ¨Ôö¼Ó¡¢É¾³ý¡¢·Ö½â¡¢ ......