mysql - Add nonexistent ID to database -

i have database starts @ id = 1000. want add entry @ id = 1. using mysql. done once, , not care rest of 2 - 999 values. concerned adding @ id = 1, id not exist cannot update it.

you can insert , define id rather allowing auto_increment normal job.

insert table (id, another_column, ... ) values (1, 'some value', ... );