Web Development

View All Threads First Prev Next

How to generate alphanumeric auto increment id in mysql Deepthi.214562-Nov-12 1:01 Deepthi.21456 2-Nov-12 1:01  How to generate alphanumeric auto increment id in mysql Re: How to generate alphanumeric auto increment id in mysql Keith Barrow2-Nov-12 1:24 Keith Barrow 2-Nov-12 1:24  Hi, We have a forum for MySql Problems, I suggest you move your post here[^] Regards, Keith Sort of a cross between Lawrence of Arabia and Dilbert.[^] -Or- A Dead ringer for Kate Winslett[^] Re: How to generate alphanumeric auto increment id in mysql Sandeep Mewara3-Nov-12 7:36 Sandeep Mewara 3-Nov-12 7:36  Have a look at this article: Auto Generate AlphaNumeric ID’s in a SQL Server Table[^] - It's for SQL Server but the around it remains the same. Sandeep Mewara Microsoft ASP.NET MVP [My latest Article]: Server side Delimiters in ASP.NET[^] Re: How to generate alphanumeric auto increment id in mysql Zamshed Farhan15-Jan-13 4:33 Zamshed Farhan 15-Jan-13 4:33  You have to store the key as two columns. A char prefix and an auto-incrementing int, both of which are grouped for the primary key. CREATE TABLE my_table( id INT NOT NULL AUTO_INCREMENT, prefix CHAR(30) NOT NULL, PRIMARY KEY (id, prefix), ... Say, prefix is here 'PRF', then you get PRF1, PRF2, PRF3, .......... Re: How to generate alphanumeric auto increment id in mysql Chioma Owuama23-Sep-22 19:51 Chioma Owuama 23-Sep-22 19:51  this didnt work only created a collum for prefix

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 21:32 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.