mysql 各种操作

创表

CREATE TABLE orders(
id INT COMMENT '这是主键',
order_date DATETIME NOT NULL DEFAULT NOW(),
customer_id INT,
PRIMARY KEY (id)
)ENGINE=INNODB DEFAULT CHARSET=utf8;

 

------------------------------------------------------------------------------------------------------

 

改变表

ALTER TABLE customer ADD sharding_id BIGINT(20) NOT NULL;

 

------------------------------------------------------------------------------------------------------