List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:April 22 2008 8:01am
Subject:Re: auto_increment
View as plain text  
Ben Clewett schrieb:
> Are you sure, I just get:
> 
> CREATE TABLE ...
> 
> ERROR 1075 (42000): Incorrect table definition; there can be only one 
> auto column and it must be defined as a key

the mentioned CREATE TABLE is fine and works


> On version 5.0.41.  What version are you using?

this works on all versions, and the example is from the MySQL manual

http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

-- 
Sebastian Mendel
Thread
auto_incrementHiep Nguyen21 Apr
  • Re: auto_incrementSebastian Mendel22 Apr
    • Re: auto_incrementSebastian Mendel22 Apr
      • Re: auto_incrementHiep Nguyen22 Apr
  • Re: auto_incrementBen Clewett22 Apr
    • Re: auto_incrementSebastian Mendel22 Apr
      • Re: auto_incrementBen Clewett22 Apr
      • PerformanceBruno B .  B .  Magalhães22 Apr
        • Re: PerformancePhil22 Apr
        • Re: PerformanceRob Wultsch22 Apr
        • Re: PerformanceRob Wultsch22 Apr
        • Re: PerformancePerrin Harkins22 Apr
          • Re: PerformanceBruno B .  B .  Magalhães22 Apr
            • Re: PerformanceRob Wultsch22 Apr