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 database DB_Name

create table tablename

(

column_name1 datatype,

column_name2 datatype,

...


TAG:

有什么比看书更美妙的 引用 删除 angelets   /   2009-07-29 12:18:50
比较简单的一些常用sql语句
 

评分:0

我来说两句

Open Toolbar