基本sql语句总结

一、创建表

 

create table shopCart
(
    id int identity,
    shopname varchar(50),
    shopcartCount int,
    shopcartContent varchar(50)
)

 

 

二、对一行数据的操作：

 

    insert into shopCart (shopname,shopcartCount,shopcartContent)values('帽子',3,'帽子是俄罗斯产的')

 

    delete from shopCart where shopname = '帽子1'

 

    update shop set shopname = '帽子1' where id = 2

 

三、对表字段的操作：

 

    alter table shopCart add xiaoguo11 varchar(50)not null default 'en'

   

    alter table shopCart drop column xiaoguo

 

     alter   table   shopCart    alter   column   xiaoguo   int   not   null   (由null改为not null)

 

==========================================

 

四、一个循环（并且实现了varchar和int数据的合并）

 

declare @i int
set @i = 1

while @i <10
  begin
      insert into shopCart (shopname,shopcartCount,shopcartContent)values('帽子'+cast(@i as varchar(5)),@i,'帽子是俄罗斯产的'+cast(@i as varchar(5)))
      set @i = @i + 1
  end

 

五、一个表的内容插入另一个表中

 

         insert into shop (shopname,shopContent) select shopname,shopcartcontent from shopcart