Re: CREATE TABLE Inv_Id

[Scott Hamm]

Thanks!



On 10/16/06, Gabriel PREDA <gabriel.preda@stripped> wrote:
>
> I would try:
>
> CREATE TABLE Inv_Id (
> ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
> MID INT NOT NULL,
> FOREIGN (MID) REFERENCES 'Model' (ID)
> );
>
> Note the UNSIGNED and ZEROFILL flags !
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Gabriel PREDA
> Senior Web Developer
>



-- 
--------------------------------------------------------------------
`Twas brillig, and the slithy toves
Did gyre and gimble in the wabe:
All mimsy were the borogoves,
And the mome raths outgrabe.
--------------------------------------------------------------------