dotti Posted May 29, 2007 Share Posted May 29, 2007 Error SQL query: CREATE TABLE `News` ( `id` INT( 3 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 20 ) NOT NULL , `author` VARCHAR( 20 ) NOT NULL , `Time` DATETIME NOT NULL , `content` TEXT NOT NULL ) ENGINE = MYISAM MySQL said: Documentation #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key Link to comment https://forums.phpfreaks.com/topic/53454-mysql-error/ Share on other sites More sharing options...
obsidian Posted May 29, 2007 Share Posted May 29, 2007 Change: `id` INT( 3 ) NOT NULL AUTO_INCREMENT To: `id` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY Link to comment https://forums.phpfreaks.com/topic/53454-mysql-error/#findComment-264227 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.