rain13 Posted October 4, 2011 Share Posted October 4, 2011 #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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.