改表SQL

//增加某列作为表主键
ALTER TABLE personal_views ADD views_id BIGINT AUTO_INCREMENT PRIMARY KEY;

//修改某列作为表主键
ALTER TABLE business_account ADD PRIMARY KEY(business_account_id);

//修改表主键
ALTER TABLE personal_v_account CHANGE v_account_id v_account_id BIGINT PRIMARY KEY AUTO_INCREMENT;

//增加唯一索引
ALTER TABLE personal_views ADD UNIQUE uq_member_id(member_id);

//增加表字段
ALTER TABLE business_account ADD business_account_id BIGINT;

//修改数据类型
ALTER TABLE personal_views MODIFY member_id BIGINT;

//删除索引
ALTER TABLE business_account DROP INDEX member_id;

//删除主键
ALTER TABLE business_account DROP PRIMARY KEY