索引
--查看
SELECT * FROM mysql.`innodb_index_stats` a WHERE a.`database_name` = 'ipms' and a.table_name = 'order_list_sync'
--新增
CREATE INDEX idx_order_list_sync_parking_lot_no on order_list_sync(parking_lot_no)
改名
ALTER TABLE 旧表名 RENAME TO 新表名;
alter table white_user change column name nick_name varchar(50) null;
RENAME TABLE order_list_sync to order_list_sync_his,order_list_sync_t to order_list_sync ;
主键
删主键
alter table 表名 drop primary key;
单主键
alter table 表名 add primary key(id)
联合主键
alter table 表名 add primary key(id,status)
ON DUPLICATE KEY UPDATE
依据主键新增,若存在则更新
INSERT INTO table1 SELECT * FROM table2
ON DUPLICATE KEY UPDATE `order_no`=VALUES(`order_no`),
`created_at`=VALUES(`created_at`), `updated_at`=VALUES(`updated_at`),
`type`=VALUES(`type`), `img`=VALUES(`img`), `status`=VALUES(`status`)