Question 0 post counts 1.5.8

So for example, I need to run,

ALTER TABLE `jos_fb_announcement` DROP INDEX ( `id` ) ;

Is that right ?

Thanks

I'm sorry, I should have explained this better.

If you want to delete the INDEX you use this syntax: If you want to delete the PRIMARY KEY you use this syntax: As we've said on many occasions, you need to be extraordinarily careful because the slightest mistake and *pow* there goes the whole ball-game. It pays to really know what you're doing and, if you're unsure, do lots of reading up on the subject in Google.

ok thanks for the help will have a go and see how I get on, don't fear I have backed up!

Thanks!

Hi,

When I run

ALTER TABLE `jos_fb_announcement` DROP PRIMARY KEY (`id`);

I get an error, is the above correct ?

The error is,

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`id`)' at line 1

SQL is version 5.0.58

Appreciate the help as I really need to get my site back up and running !

Thanks

The correct syntax is

Hi,

I ran that and get,

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

Thanks.