Adding to id number!

[Anon]

Hi,

Is there anyway of adding 1120 to an id coloum in a database?

For example: a story has an original id of 58 after adding the 1120, the id would be 112058.

Is there anyway of doing this without changing each id individually?

Thanks

Daniel

[[deleted]]

Why would you want to do this?

[Anon]

I don't know how you id works but if you use sql query update table set id = id + 112000 then all id will be have 1120 in front of them

[tomhath]

That's not what I would call addition. And if you don't change them individually, how else could they be changed?

Changing a number to character and concatenating strings then changing back to numbers is simple. Modifying an autoincremented column is not so simple. What are you trying to do?

[Anon]

I have an autoincrement coloum for my id, all I want to do is for evey set data, I want to add 1020 to the id so the id would show up as 1020xx (x=previous id number)!

[tomhath]

Getting the number you want is easy (as I said in my earlier post, what you are trying to do is a string concatenation). I don't know if there is a way in mysql to modify an autoincrement column; doing so would defeat the whole purpose of autoincrementing.

How about adding another column to the table and using it with the 1020xx id convention you have instead of messing with the primary key? If you need a flag or sort order you should definitely use another column.

[Anon]

Why change the idea of autoincrement.... the only idea about it is that it picks a following number for you.... the problem with most autoincrements is that is skips some number or do not use number that has come free in the meantime......

So fist of all make your number a string add 1020 and make it an numeric again. second of all remove the stupid autoincrement thing.... make your own following number..... or unique number..... just know you should lock the table's new inserts before you insert a row otherwise you get errors when they come to insert at the exact same time !!!