- Code: Select all
insert into table1 (record_id, columnA, columnB, columnC)
select record_id, columnA, columnB, '123456789'
from table1
where record_id between 1710330 and 1710500
Thanks in advance for any suggestions.
insert into table1 (record_id, columnA, columnB, columnC)
select record_id, columnA, columnB, '123456789'
from table1
where record_id between 1710330 and 1710500
INSERT into table1 (columnA, columnB, columnC)
SELECT columnA, columnB, '123456789'
FROM table1
WHERE record_id BETWEEN 1710330 AND 1710500
Users browsing this forum: No registered users and 20 guests