mysql 通过主键搜索_mysql 修改主键

mysql 修改主键

2018-09-19 09:34

阅读数 12

ALTER TABLE `test2` DROP PRIMARY KEY ,ADD PRIMARY KEY ( `id` )

重设主键字段

有时数据库操作时需要将一个主键修改为联合主键或者把主键改为其他列，这时候单纯的add primary key是没有用的，必须先删除主键约束再重新添加。

MYSQL:

1、alter table TABNAME drop primary key;

2、alter table TABNAME add primary key(another_col,...);

查看是否支持分区

SHOW VARIABLES LIKE '%partition%';

增加分区

ALTER TABLE apklog_submit

PARTITION BY RANGE ( TO_DAYS(up_date) ) (

PARTITION p0 VALUES LESS THAN ( TO_DAYS('2008-01-01 00:00:00') ),

PARTITION p1 VALUES LESS THAN ( TO_DAYS('2008-04-01 00:00:00') ),

PARTITION p2 VALUES LESS THAN ( TO_DAYS('2008-07-01 00:00:00') ),

PARTITION p3 VALUES LESS THAN ( TO_DAYS('2008-10-01 00:00:00') ),

PARTITION p4 VALUES LESS THAN ( TO_DAYS('2009-01-01 00:00:00') ),

PARTITION p5 VALUES LESS THAN ( TO_DAYS('2009-04-01 00:00:00') ),

PARTITION p6 VALUES LESS THAN ( TO_DAYS('2009-07-01 00:00:00') ),

PARTITION p7 VALUES LESS THAN ( TO_DAYS('2009-10-01 00:00:00') ),

PARTITION p8 VALUES LESS THAN ( TO_DAYS('2010-01-01 00:00:00') ),

PARTITION p9 VALUES LESS THAN (MAXVALUE)

);