sql常用语句
上一篇 /
下一篇 2009-07-21 11:35:43
/ 个人分类:数据库
1. Select & distinct
select colum1,colum2 ...
from tablename
where colum1=value1 and colum2=value2 |
slect distinct colum1,colum2...
from tablename |
2.Insert
insert into tablename
values (value1,value2...) |
insert into tablename (colum1,colum2...)
values (value1,value2...) |
3.update
update tablename
set colum1=value1, colum2=value2...
where somecolum=somevalue |
4.delete
delete from tablename
where colum1=value1 |
5.Top & order by
select top 10
from tablename
order by colum1 asc|desc |
6.like与通配符
select * from tablename
where colum1 like 's%' |
7.count & distinct
select count(distinct colum1)
from tablename |
8.in & (between and)
select column(s)
from tablename
where column1 in (value1,value2...) |
select column(s)
from tablename
where column1 between value1 and value2 |
9.create database & create table
create table tablename
(
column_name1 datatype,
column_name2 datatype,
... |
收藏
举报
TAG: