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
You can do that using a "before insert" trigger, something like (untested) :
CREATE TRIGGER test1bi
BEFORE INSERT ON test1
FOR EACH ROW BEGIN
NEW.ID = COALESCE( NEW.ID, SHA1(CAST(RAND() AS CHAR)))
END;
2007/8/7, shivendra <[EMAIL PROTECTED]>:
>
>
> Hi, I'm looking for some basic help. I
