select distinct column_name form table_name --------- distinct指定检索独有的列值，不重复

select stocknumber ,"stocknumber + 10" = stocknumber + 10 from table_name

select stockname , "stocknumber" = count(*) from table_name group by stockname

--------- group by 将表按行分组,指定列中有相同的值

having count(*) = 2---------having选定指定的组

select *

from table1, table2

where table1.id *= table2.id -------- 左外部连接，table1中有的而table2中没有得以null表示

table1.id =* table2.id -------- 右外部连接

select stockname from table1

union [all]-----union合并查询结果集，all-保留重复行

select stockname from table2

***insert***

insert into table_name (Stock_name,Stock_number) value ("xxx","xxxx")

value (select Stockname , Stocknumber from Stock_table2)---value为select语句

***update***

update table_name set Stockname = "xxx" [where Stockid = 3]

Stockname = default

Stockname = null

Stocknumber = Stockname + 4

***delete***

delete from table_name where Stockid = 3

truncate table_name ----------- 删除表中所有行，仍保持表的完整性

drop table table_name --------------- 完全删除表

***alter table*** --- 修改数据库表结构

alter table database.owner.table_name add column_name char(2) null .....

sp_help table_name ---- 显示表已有特征

create table table_name (name char(20), age smallint, lname varchar(30))

insert into table_name select .

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] 下一页