| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Scott Hamm | Date: | October 16 2006 6:19pm |
| Subject: | CREATE TABLE Inv_Id | ||
| View as plain text | |||
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?
--
--------------------------------------------------------------------
`Twas brillig, and the slithy toves
Did gyre and gimble in the wabe:
All mimsy were the borogoves,
And the mome raths outgrabe.
--------------------------------------------------------------------
| Thread | ||
|---|---|---|
| • CREATE TABLE Inv_Id | Scott Hamm | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Gerald L. Clark | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Scott Hamm | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Rolando Edwards | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Gabriel PREDA | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Scott Hamm | 16 Oct |
| • Re: CREATE TABLE Inv_Id | Dan Buettner | 16 Oct |
| • Re: Re: CREATE TABLE Inv_Id | Martijn Tonies | 19 Oct |
| • RE: Re: CREATE TABLE Inv_Id | Jerry Schwartz | 19 Oct |
| • Re: CREATE TABLE Inv_Id | Scott Hamm | 19 Oct |
| • Re: Re: CREATE TABLE Inv_Id | Dan Buettner | 19 Oct |
