query insert help

[MDanz]

i have a column called origin which is type integer(not ascending or descending). All rows have an origin assigned to them can't be duplicated... like two rows with the same origin(integer).

 

 

when inserting a new row.  Just say row 1 has origin 15 and i'm inserting a new row with the same origin(15) how do i go to the next available integer to prevent a duplicate origin?

[Ken2k7]

Why not set the column to be a primary key and auto increment? If you did that, you won't have to worry about it.

[andrewgauger]

INSERT INTO table_name SET origin=(SELECT MAX(origin) FROM table_name)+1

 

[fenway]

INSERT INTO table_name SET origin=(SELECT MAX(origin) FROM table_name)+1

 

That's a bad idea -- not thread-safe -- use auto-increment as suggested earlier.