一.mysql的常用增删改查命令
1. 添加:
INSERT INTO t_users (NAME,Age) VALUES(name,age);
2.删除:
DELETE FROM t_users WHERE NAME = "name";
3. 修改:
UPDATE t_users SET Age= "age" WHERE NAME = "name"
4.查询:
SELECT * FROM t_users WHERE NAME = "name";
5.分页
SELECT * FROM t_users LIMIT (当前页码-1)* 每页记录数, 每页记录数
二、sql server的常用增删改查命令
1. 添加:
INSERT INTO t_users (NAME,Age) VALUES(name,age);
2.删除:
DELETE FROM t_users WHERE NAME = "name";
3. 修改:
UPDATE t_users SET Age= "age" WHERE NAME = "name"
4.查询:
SELECT * FROM t_users WHERE NAME = "name";
5.分页:
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID