TalkPHP - View Single Post - importing table and getting error. need help

Orc · 02-06-2008, 11:06 AM

Hell yeah it has to be a primary key, that's probably the only reason, there are two ways to do this:

1.

sql Code:

CREATE TABLE `blah` (
       `id` int(5) NOT NULL AUTO_INCREMENT PRIMARY KEY
);

2. [highlight=sql]
CREATE TABLE `bleh2` (
`id` int(5) not null auto_increment,
KEY `id` ( `id` ) // OR this
PRIMARY KEY (`id`)
);
[/hightlight]

Your choice, they all work the same way.

Edit: What the crap?

02-06-2008, 11:06 AM	#3 (permalink)
Orc The Prestige Join Date: Dec 2007 Posts: 1,044 Thanks: 193	Hell yeah it has to be a primary key, that's probably the only reason, there are two ways to do this: 1. sql Code: CREATE TABLE `blah` ( `id` int(5) NOT NULL AUTO_INCREMENT PRIMARY KEY ); 2. [highlight=sql] CREATE TABLE `bleh2` ( `id` int(5) not null auto_increment, KEY `id` ( `id` ) // OR this PRIMARY KEY (`id`) ); [/hightlight] Your choice, they all work the same way. Edit: What the crap? __________________ VillageIdiot can have my babbies ;d