select * into xyz2808 from xyz808 while right( xyz808.m808,4

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/07/13 12:48:03

select * into xyz2808 from xyz808 while right( xyz808.m808,4) like '2808'
我想从表xyz808中查询出列m808（字符型）的值右边4位等于 2808,写入新表xyz2808

如果xyz2808表没有的话可以这样写
select * into xyz2808 from xyz808 where right(xyz808.m808,4) like '2808'
如果xyz2808表已存在就要这样写
insert into xyz2808
select * from xyz808 while right( xyz808.m808,4) like '2808'
当然你的列的数量两个表要对应

select * into dept2 from dept select * into b from a where 11 insert into a select * from b 和select * into a from b 这两个语句是数据库中select into from 和 insert into select的区别 select count() into :r_count from zw_kmyeb where km_code lik select hkont from bseg into table itab_bseg where ( hkont li insert into REC_OVER(ORG_ID) select '1' from dual where not 英语翻译select top 4 * from shop_books where anclassid = (select select * into a from a..a 请问,这句中的a....有什么用 select*from ‘ * ’ 的意义? select * from book limit , select Insert into和Insert into select的区别