Re: Concat Prefix with Id and autoincrement it uisng trigger in Mysql

[Peter Brawley]

It's not recommended. What problem are you trying to solve?

If you're determined to do it, the value assignment must be in a transaction. Then given a prefix column named `prefix` with a value 'foo' ...

start transaction;
  select @id := 1+max(id) from animals where prefix='foo' for update;
  insert into animals(foo, id, ...) values(foo, @id, ...)
commit;