mysql
1.获取记录的最大id数.
(1)select MAX(id) FROM 表名;
(2)如果id是递增的,
SELECT ID FROM 表名 ORDER BY ID DESC LIMIT 1;
sqlserver:
查询某个数据库下面表的数量:
use 数据库名;
select count(*) as TableCount from sysobjects where type='u' and status>=0;
mysql
1.获取记录的最大id数.
(1)select MAX(id) FROM 表名;
(2)如果id是递增的,
SELECT ID FROM 表名 ORDER BY ID DESC LIMIT 1;
sqlserver:
查询某个数据库下面表的数量:
use 数据库名;
select count(*) as TableCount from sysobjects where type='u' and status>=0;