List:MySQL ODBC« Previous MessageNext Message »
From:Paul DuBois Date:June 16 2001 11:54pm
Subject:Re: MySQL + Win2000 = AUTO_INCREMENT field bug?
View as plain text  
At 4:08 PM -0400 6/16/01, Andres Becerra wrote:
>I can't seem to create a table with an AUTO_INCREMENT column on the Win2000
>version of MySQL
>
>create table tbOrder (
>	OrderID      	decimal(9,0) 	    	PRIMARY KEY 
>auto_increment default 0,
>	...etc...
>);
>
>Has anybody comes across this before?  I can find nothing in the docs on
>this...

AUTO_INCREMENT is for integer types, not DECIMAL.

>
>Thanks,
>Andres


-- 
Paul DuBois, paul@stripped
Thread
Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham13 Jun
  • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsHans Christiansen13 Jun
    • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham13 Jun
    • RE: Cold Fusion + Solaris + mySQL + MyODBC = problemsfcanavati15 Jun
      • RE: Cold Fusion + Solaris + mySQL + MyODBC = problemsFederico Balbi15 Jun
        • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham15 Jun
          • MySQL + Win2000 = AUTO_INCREMENT field bug?Andres Becerra16 Jun
            • Re: MySQL + Win2000 = AUTO_INCREMENT field bug?Paul DuBois17 Jun
              • RE: MySQL + Win2000 = AUTO_INCREMENT field bug?Andres Becerra17 Jun
                • RE: MySQL + Win2000 = AUTO_INCREMENT field bug?Paul DuBois17 Jun