List:General Discussion« Previous MessageNext Message »
From:Gerald L. Clark Date:October 16 2006 6:31pm
Subject:Re: CREATE TABLE Inv_Id
View as plain text  
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
Thread
CREATE TABLE Inv_IdScott Hamm16 Oct
  • Re: CREATE TABLE Inv_IdGerald L. Clark16 Oct
    • Re: CREATE TABLE Inv_IdScott Hamm16 Oct
    • Re: CREATE TABLE Inv_IdRolando Edwards16 Oct
    • Re: CREATE TABLE Inv_IdGabriel PREDA16 Oct
      • Re: CREATE TABLE Inv_IdScott Hamm16 Oct
  • Re: CREATE TABLE Inv_IdDan Buettner16 Oct
  • Re: Re: CREATE TABLE Inv_IdMartijn Tonies19 Oct
    • RE: Re: CREATE TABLE Inv_IdJerry Schwartz19 Oct
Re: CREATE TABLE Inv_IdScott Hamm19 Oct
  • Re: Re: CREATE TABLE Inv_IdDan Buettner19 Oct