You may want to simulate autoincrementing
by means of Triggers
You may need to make ID a 12 character string first.
Then create a trigger something like this:
CREATE TRIGGER addingInv BEFORE INSERT ON Inv_Id
FOR EACH ROW SET @ID= '...'
You will have to also add what Gerald mentioned (casecode prefix,
a manufacturers id, a partnumber, and a check digit) to the table definition.
----- Original Message -----
From: Gerald L. Clark <gerald_clark@stripped>
To: Scott Hamm <linuxgold@stripped>
Cc: Mysql <mysql@stripped>
Sent: Monday, October 16, 2006 2:31:47 PM GMT-0500 US/Eastern
Subject: Re: CREATE TABLE Inv_Id
Scott Hamm wrote:
> I'm trying to create a table as follows:
>
> CREATE TABLE Inv_Id (
> ID INT(12) AUTO_INCREMENT PRIMARY KEY,
> MID INT NOT NULL,
> FOREIGN (MID) REFERENCES 'Model' (ID)
> );
>
> How do I make ID to start out as '000000000001' for UPC barcode assignment?
UPC barcodes are not sequential numbers.
They are composed of a casecode prefix, a manufacturers id, a
partnumber, and a check digit.
You cannot use an autoincrement number as a UPC.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
