且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

ALTER TABLE 添加复合主键

更新时间:2023-11-30 19:13:46

ALTER TABLE provider ADD PRIMARY KEY(person,place,thing);

如果主键已经存在,那么你想这样做

If a primary key already exists then you want to do this

ALTER TABLE provider DROP PRIMARY KEY, ADD PRIMARY KEY(person, place, thing);