查询:
select * from table
增加/插入:
insert into table(name1,name2,) values ('列1','列2');
修改/更新
update table set name1='张三',name2='李四' where id=500;
删除:
delete from table where id=300;
删除table 表里id=300的这条数据
TOP语句的不同
SELECT TOP 子句用于规定要返回的记录的数目。
SQL Server / MS Access 语法:
SELECT TOP number|percent column_name(s)
FROM table_name;
MySQL 语法
SELECT column_name(s)
FROM table_name
LIMIT number;
SELECT *
FROM Persons
LIMIT 5;
Oracle 语法
SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;
SELECT *
FROM Persons
WHERE ROWNUM <=5;
ORDER BY 关键字用于对结果集进行排序
ORDER BY 关键字默认按照升序对记录进行排序。如果需要按照降序对记录进行排序,您可以使用 DESC 关键字。
SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;