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/[EMAIL PROTECTED]