insert into 表A(name,age,home,sex) select * from 表B
如果id列为自动编号或者允许为空:insert into A(name,age,home,sex) select * from B或insert into A(name,age,home,sex) select name,age,home,sex from B 如果ID不允许为空,且不是自动编号,则必须在insert时一起处理。
如果表B是一个VIEW视图呢,能用insert into A(name,age,home,sex) select * from B吗
insert into a(name,age,home,sex) from select name,age,home,sex from b
insert into per_musicbg (title,musicurl,username) (select title,musicurl,username from per_music where id = 1)现在我想 per_musicbg 里有一列 名:xulie 我是要传个值进来 用上面的 语句合并 insert into per_musicbg (title,musicurl,username,xulie) (select title,musicurl,username from per_music where id = 1)(50)这样肯定不对,有人能说下怎么写吗?
如果id列为自动编号或者允许为空:insert into A(name,age,home,sex) select * from B或insert into A(name,age,home,sex) select name,age,home,sex from B
如果ID不允许为空,且不是自动编号,则必须在insert时一起处理。
insert into per_musicbg (title,musicurl,username,xulie) (select title,musicurl,username from per_music where id = 1)(50)这样肯定不对,有人能说下怎么写吗?