List:General Discussion« Previous MessageNext Message »
From:Scott Hamm Date:October 16 2006 7:02pm
Subject:Re: CREATE TABLE Inv_Id
View as plain text  
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.
--------------------------------------------------------------------

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