error 1064

[hanpedro]

I have an error #1064 as follows;

APM Environment:

- Apache 2.2.9
- MySQL 5.0.67
- PHP 5.2.6

Error Message:

error
SQL query:

ALTER TABLE g4_auth DROP INDEX PRIMARY ;



MySQL message: 

#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 'PRIMARY' at line 1 

How to resolve this error message?

[nevvermind]

Either DROP PRIMARY KEY, or DROP INDEX index_name.

Link. (Read it! - I get cranky when it gets to DROPPING in mysql)

[hanpedro]

nevvermind/ Thanks for your kind information.

I'll study.