通用 sql | 数据库 命令

基础教程：

选择 | 条件 | 排序 | 插入 | 更新 | 删除 |

select| where| order by| insert into| update| delete |

---

select 选择:

select *(column_name1,column_name2…) from table_name;

select distinct 唯一不重复。

---

where 条件语句:
select * from table_name where column_name=’’;
select * from table_name where column_name=’’ like…in…between…regexp…;

and 满足两个条件 select * from table_name where xx and xx ;

or 满足其中一个条件;

---

order by 升序:

select * from table_name order by column_name;

order by column_name desc(descending) 降序。

insert into 插入:
insert into table_name values(’’,’’,’’,);

insert into table_name (column_name1,column_name2…)
values (value1,value2,value3…);

update 更新:

update table_name set column_name1=’’,column_name2=’’…
where column_name=’’;

delete 删除行 delete from table_name where column_name=’’;

---

高级教程：

select top | like | %/- | in | between| as |

数目    | 模糊搜索 | 通配符 |  包含可能值|  范围  |  别名  |

---

---

join | union | select into | create database | create table |

连接 | 连接 | 复制1表到2 | 创建数据库 | 创建表 |

---

| constraint | create index | drop | alte table | auto_increment |

| 约束 | 创建索引 | 删除行 | 添加删除或修改列 | 自增 |

---

create view | datetime| null | ifnull |

视图       |   日期	 | 保守值 | null函数 |

---

---

select top 数目：
SQL Server / MS Access : select top number|percent column_name from table_name;
MySQL : select top column_name from table_name li