MYSQL: Bikin auto increment with prefix. Ex: GSF00001

aiconcat.txt

SELECT CONCAT('ABC1',LPAD(id,5,'0')) FROM tablename;

http://stackoverflow.com/questions/3245429/autoincrement-of-table-id-using-string-combination-in-database-automatically
http://stackoverflow.com/questions/12424153/how-to-use-auto-increment-value-in-mysql-concat-function
http://stackoverflow.com/questions/10605383/mysql-creating-a-table-with-auto-increment-and-concatenating-the-values-generat
http://stackoverflow.com/questions/17266442/in-mysql-how-can-i-use-the-autoincrement-value-in-another-column-at-the-time-of