02-06-2008, 11:06 AM
|
#3 (permalink)
|
|
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
|
|
|
|