i have a column in mysql called origin which is type integer(not ascending or descending). All rows have an origin assigned to them can't be duplicated... e.g. 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?