samedi 27 juin 2015

mysql 5.6 drop primery key not working

I want to drop primery key constraint from my table.

mysql> alter table 'carpool' drop PRIMERY KEY, add PRIMERY KEY('pool_id'); ERROR 1064 (42000): 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 ''carpool' drop PRIMERY KEY, add PRIMERY KEY('pool_id')' at line 1

I have checked mysql manual and other similar question in stack overflow but none is able to solve my problem

Any help will be appreciated

Aucun commentaire:

Enregistrer un commentaire