基本语法就不详细描述了,该文档主要记录复习sql语句时写的所有语句(以前总结的)
简单查找
select * from table;
查找不重复的项
select distinct * from table;
where语句查找
select * from table where name ='jack';
and or 语句
select * from table where name='jack' and age=18;
排序(默认升序asc,降序用desc)
select * from table where age>3 order by age (desc);
插入语句
insert into table(column_name) values ('jack',12,'1992-29-1');
更新语句
update table set colunmn_name='ppp' where name ='jack';
删除某条信息语句
delete from table where name='jack';
删除表
drop table if exists table_name;
SELECT - 从数据库中提取数据
UPDATE - 更新数据库中的数据
DELETE - 从数据库中删除数据
INSERT INTO - 向数据库中插入新数据
CREATE DATABASE - 创建新数据库
ALTER DATABASE - 修改数据库
CREATE TABLE - 创建新表
ALTER TABLE - 变更(改变)数据库表
DROP TABLE - 删除表
CREATE INDEX - 创建索引(搜索键)
DROP INDEX - 删除索引
高级教程
得到查找到的信息的前几个
MySQL: select age from table order by age desc limit 10;
Oracle: select age from table where ROWNUM<=10;
SQL Server: select top 5 age from table;
select top 50 percent age from table order by age asc;
Like的用法
select * from table where name like 'j%';
select * from table where name like '_a%';
IN的用法
select * from table where name in ('jack','Simth','Fuck');
between的用法
select * from table where age between 0 and 10;
给表取别名(方便书写和理解)
select w.name,w.url from websites as w;
表的连接(几种写法)
内连接: select w.name ,a.age from websites as w join access_log as a on w.id=a.site_id;
select w.name ,a.age from websites as w,access_log as a where w.id=a.site_id
左连接: le