sql数据库第一课

--使用指定的数据库
use student

--查询语句select：查询*：所以列 from：从哪个表
select *from Students

--插入语句
insert into Students
(ID,Xuehao,SName,Sex,Age,IdentityCard,SEmail,Address)
values(9,1009,'肖8',1,23,'837434374347234','hda@jsd','浙江金华')

--省略列名的插入语句
insert into Students
values (10,1010,'钱9',0,26,'636483647836483','jdsfj@163.com','浙江温州')

insert into Students
values (11,1011,'肖云斌',1,23,'330327199011171993','xsdjh@163.com','浙江温州')

select *from Students
insert into Tongxuelu values(15,'张1',1)
insert into Tongxuelu values(16,'张2',0)
insert into Tongxuelu values(17,'张3',1)
select * from Tongxuelu

--删除表内容
delete Tongxuelu where [ID]=3

--从一个表取输出插入
insert into Students(ID,SName,Sex)
select ID,SName,Sex from Tongxuelu

--与以上语句的区别在于：不需要创建表结构
--自动创建一个表和结构将数据插入进去

select SName,Address
into Stubak
from Students

select * from StuBak

--从新排列标识列的方式，as 列名 代表取别名

select identity(int,1,1)as ID ,SName,Address
into SBK
from Students

select * from SBK

转载于:https://www.cnblogs.com/xyb1117/archive/2012/02/28/2371637.html