insert into Favorite (title,url,className,userid,time) (select 'test title','http://www.3dxm.com','testclass', ID,getdate() from [user])
insert into Favorite (userid) (select ID from [user])
从一个表查询数据插入另一个表
最新推荐文章于 2023-10-19 14:05:26 发布