本文共 1177 字，大约阅读时间需要 3 分钟。

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.21sqlserver里面序列的用法/****** 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')

转载地址：https://chenyu.blog.csdn.net/article/details/49232047 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！