Re: How to create Auto Incremented and auto generated ID in sql

[Peter Brawley]

Trying to combine text and digits in a column is usually a design mistake. Better to maintain two columns and index as desired.

if the table is MyISAM, see http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html.

InnoDB does not innately support auto_increment prefixes, so if the table is InnoDB, in a Trigger inside a transaction set the prefix column and calculate the value of the int colum n as (select 1+max(colname) from tablename for update).