大家好,请问一下这两种创表有什么区别?
一种:
create table Login
(
uname varchar(20),
upwd varchar(20)
)
insert into Login(uname,upwd) values('hao','123')
insert into Login(uname,upwd) values('ya','123')二种:
create table Login(uname varchar(20),upwd varchar(20))
insert into Login select 'hao','123'
union all select 'ya','123'
一种:
create table Login
(
uname varchar(20),
upwd varchar(20)
)
insert into Login(uname,upwd) values('hao','123')
insert into Login(uname,upwd) values('ya','123')二种:
create table Login(uname varchar(20),upwd varchar(20))
insert into Login select 'hao','123'
union all select 'ya','123'
书写方式不一样