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