mysql分页原理和sqlserver里面序列的用法

  

   

    

     

    
    

     

      mysql使用经验 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      1.比如分页
     
    
   

    

     

    
    

     

      select * from table limit 6
     
    
   

    

     

    
    

     

      和select * from table limit 0,6  等价
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      select * from table limit 5,10；
     
    
   

    

     

    
    

     

      一般前面的5放的是 漂移 后面的10放的是 一页多少行
     
    
   

    

     

    
    

     

      拿到数据库 table里面的数据是 第6条到15条 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      42.121.56.21
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      sqlserver里面序列的用法
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      /****** Script for SelectTopNRows command from SSMS  ******/
     
    
   

    

     

    
    

     

      SELECT TOP 1000 [id]
     
    
   

    

     

    
    

     

       ,[username]
     
    
   

    

     

    
    

     

       ,[password]
     
    
   

    

     

    
    

     

       ,[telephone]
     
    
   

    

     

    
    

     

        FROM [MyWeb].[dbo].[adminusers]
     
    
   

    

     

    
    

     

        /****** Script for SelectTopNRows command from SSMS  ******/
     
    
   

    

     

    
    

     

      SELECT TOP 1000 [id]
     
    
   

    

     

    
    

     

       ,[username]
     
    
   

    

     

    
    

     

       ,[password]
     
    
   

    

     

    
    

     

       ,[telephone]
     
    
   

    

     

    
    

     

        FROM [MyWeb].[dbo].[adminusers]
     
    
   

    

     

    
    

     

        create squences a;
     
    
   

    

     

    
    

     

        USE MyWeb ;
     
    
   

    

     

    
    

     

        create sequence userid;
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

        USE AdventureWorks2012
     
    
   

    

     

    
    

     

        insert  ibto [MyWeb].[dbo].[adminusers] values(NEXT VALUE FOR userid,'chenyu','123','13212617498');
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

        CREATE SCHEMA Test1;
     
    
   

    

     

    
    

     

        CREATE SEQUENCE Test1.CountBy2
     
    
   

    

     

    
    

     

       START WITH 1
     
    
   

    

     

    
    

     

       INCREMENT BY 1 ;
     
    
   

    

     

    
    

     

        GO
     
    
   

    

     

    
    

     

        SELECT NEXT VALUE FOR Test1.CountBy2 AS FirstUse;
     
    
   

    

     

    
    

     

        SELECT NEXT VALUE FOR Test.CountBy1 AS SecondUse;
     
    
   

    

     

    
    

     

        INSERT [MyWeb].[dbo].[adminusers](id,username,password,telephone)
     
    
   

    

     

    
    

     

       VALUES (NEXT VALUE FOR Test.CountBy1,'chenxuan','123','13212617498') ;
     
    
   

    

     

    
    

     

      commit;
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      INSERT [MyWeb].[dbo].[adminusers] (id,username,password,telephone)VALUES (NEXT VALUE FOR Test1.CountBy2,'biyu','123','123456789') 
     
    
  
 

文章来源: chenyu.blog.csdn.net，作者：chen.yu，版权归原作者所有，如需转载，请联系作者。

原文链接：chenyu.blog.csdn.net/article/details/49232047