User Tools

Site Tools


technical_notes:public:mysql-faq

Parent

Mysql - FAQ

It's not a FAQ in the common sens, more a series of snippets to do some specific operation

How to modify primary key from an existing table ?

ALTER TABLE tbl_name DROP PRIMARY KEY;
ALTER TABLE tbl_name ADD PRIMARY KEY (`col1`, `col2`)
technical_notes/public/mysql-faq.txt · Last modified: 2013/10/06 18:44 by Fabien Arcellier