Jump to content


Photo

Auto column & defining key help


  • Please log in to reply
1 reply to this topic

#1 circpros

circpros
  • New Members
  • Pip
  • Newbie
  • 9 posts

Posted 12 October 2005 - 04:03 AM

I'm trying to create a table from a forum modification with this command:

CREATE TABLE `phpbb_ina_cat` ( 
                     `cat_id` mediumint(8) NOT NULL auto_increment, 
                     `mod_id` mediumint(8) default NULL, 
                     `cat_name` varchar(100) default NULL, 
                     `cat_desc` text, 
                     `icon` varchar(255) default NULL, 
                     `special_play` smallint(5) NOT NULL default '0', 
                     `last_game` varchar(25) default NULL, 
                     `last_player` mediumint(8) default NULL, 
                     `last_time` int(11) default NULL );

And it gives me this error:

#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key


I'm new to using mysql, and I'm not certain how to define the key. I'm also not seeing where I am defininf multiple auto colums.

I'm hoping someone more experienced than I can point out the problem for me.... Thanks in advance.

#2 circpros

circpros
  • New Members
  • Pip
  • Newbie
  • 9 posts

Posted 12 October 2005 - 04:09 AM

Got it... Missing the "PRIMARY KEY ( `cat_id` )".

I knew it had to be an easy fix, but the error syntax was leading me to belive it was more intricate.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users