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 µ¹ÐòÅÅÁС£
Ïà¹ØÎĵµ£º
Transact_SQLСÊÖ²á
*******************Transact_SQL********************
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT & ......
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º
create table myseq ( &nb ......
1¡¢±à¼MySQLÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQLd]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
±£´æÍ˳ö±à¼¡£
2¡¢È»ºóÖØÆôMySQL·þÎñ
windows»·¾³ÖУº
net stop MySQL
net start MySQL
linux»·¾³ÖÐ ......
1.Í£µômysqld
service mysqld stop
2.ÖØÆômysqld£¬Ö¸¶¨²ÎÊý
service mysqld start --skip-networking --skip-grant-tables
»òÕß
/opt/mysql/bin/mysqld_safe --skip-networking --skip-grant-tables &
/opt/mysql/ÊÇÎÒµÄMYSQL°²×°Â·¾¶
skip-grant-tables:Á¬½ÓʱÌø¹ýÊ ......