Re: Generate char surrogate key

On Friday 19 March 2004 19:25, Josué Maldonado wrote:
> Hello list,
>
> Have a table with char(3) column, the column should contain values like
> '001','002','003'... and so on, keys must be correlatives no
> '001','005','007' should be allowed, any idea how to get it done using a
> trigger?

You can lock the table, then do something like:
  SELECT key_column FROM table_name ORDER BY key_column DESC LIMIT 1;
Add one to the value you get and that's the next in order.

Of course that won't help you if there are deletions/renumberings etc.

--
  Richard Huxton
  Archonet Ltd