Jump to content


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


Auto column & defining key help

Recommended Posts

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.

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.