Jump to content

[Solved] Auto_Increment Issue


rain13

Recommended Posts

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
This doesn't work
CREATE TABLE FORUM (ForumID INT( 11 ) AUTO_INCREMENT ,ForumName varchar( 260 ) ,ForumType tinyint( 1 ))

But this does work

CREATE TABLE FORUM (ForumID INT( 11 ),ForumName varchar( 260 ) ,ForumType tinyint( 1 ))

How I can have multiple tables with AUTO_INCREMENT attribute? Edit: I didn't have primary key

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...