I have a table which does not have any auto increments. I have to insert data into this table, each time incrementing the ID by 1000.
So I have
SELECT @maxId = Max(ID)
INSERT INTO TABLE1
(@maxId + 1000, DATA),
(@maxId + 2000, DATA),
(@maxId + 3000, DATA)
There is nothing stopping you from doing the following and getting the data inserted correctly.
insert into table1(ID,DATA) VALUES ((select max(id) from table1 as T) +1000, DATA), ((select max(id) from table1 as T) +1000, DATA);
Or is it something else that you meant?