w to do this in MySQL?
--
View this message in context: http://www.nabble.com/auto-increment-
format-tf4229677.html#a12032917
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
On 8/7/07, Boyd Hemphill <[EMAIL PROTECTED]> wrote:
>
> Suggestions to use a hash are a problem because once you have a few
> million rows the likelihood of a collision is quite high if you cannot
> afford an error stopping your application. This means that if you write a
> trigger (the obvious wa
Shivendra:
It looks to me based on your example that you are creating a "smart field"
where the first three chars are some sort of category and the numeric part is
"random". If you example is accurate then a char(3) field and a standard
auto_increment field will do the trick. If uniqueness i
deserve,
>
> __
> Lucas Heuman
> Web Developer
> Ricomm Systems Inc.
> FAA, WJHTC/Bldg 300, 3nd Fl., L33
> Atlantic City Int'l Airport, NJ 08405
> Phone 609.485.5401
>
>
>
> "Olexandr Melnyk" <[EMAIL PROTECTED]&g
City Int'l Airport, NJ 08405
Phone 609.485.5401
"Olexandr Melnyk" <[EMAIL PROTECTED]>
08/07/2007 08:19 AM
To
mysql@lists.mysql.com
cc
Subject
Fwd: auto increment format
You can do that using a "before insert" trigger, something like (untested)
:
CRE
do this
> automatically, everytime a record is added. For example, ord5001, ord5002,
> ord5003, etc. Does anyone know how to do this in MySQL?
> --
> View this message in context:
> http://www.nabble.com/auto-increment-format-tf4229677.html#a12032917
> Sent from the MySQL - Gen
ut do this
automatically, everytime a record is added. For example, ord5001, ord5002,
ord5003, etc. Does anyone know how to do this in MySQL?
--
View this message in context:
http://www.nabble.com/auto-increment-format-tf4229677.html#a12032917
Sent from the MySQL - General mailing list archive at
