INSERT INTO TEST_TO
SELECT TOP 1 *
FROM TEST_FROM
ORDER BY id DESCINSERT INTO TEST_TO
(
SELECT TOP 1 *
FROM TEST_FROM
ORDER BY id DESC
)以上两个语句的目的是想从 from 表中获取到 id 最大的那条记录,然后插入表to
为何加了括号把select括起来反而会报错呢?我觉得加了()才更准确并且才能正确,为何执行效果恰好相反呢[第一个是正确,而第二个错误]?
调试欢乐多
insert into (字段) values(字段值)
insert into (字段)
select 字段值