常用mysql的增删查改_mysql的常用增删改查命令

一.mysql的常用增删改查命令

新增：

INSERT INTO t_users (NAME,Age) VALUES(name,age);

2.删除：

DELETE FROM t_users WHERE NAME = "name";

修改：

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的常用增删改查命令

添加：

INSERT INTO t_users (NAME,Age) VALUES(name,age);

2.删除：

DELETE FROM t_users WHERE NAME = "name";

修改：

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