Mysql常用sql语句

创建表格：
CREATE TABLE contact(
id INT(4),
name VARCHAR(25),
phone INT(11),
labal VARCHAR(10)
);

CREATE TABLE STOCK(
Id INT(6) NOT NULL AUTO_INCREMENT,
volume_change VARCHAR(4),
opening VARCHAR(6),
closing VARCHAR(6),
tail VARCHAR(10),
trading_day VARCHAR(2),
mf VARCHAR(5),
flow_to VARCHAR(5),
result VARCHAR(2),
volume decimal(10,2),
flow_volume decimal(10,2),
tail_flow VARCHAR(2),
market VARCHAR(10),
mfv decimal(10,2),
PRIMARY KEY (Id)
)

添加表字段：ALTER TABLE poem ADD flag INT UNSIGNED DEFAULT 0
alter table car_evidence drop column unit_name;

字符串转日期
STR_TO_DATE(‘2020-04-17’,’%Y-%m-%d’)
日期转字符串
date_format(‘2013-03-09’,’%Y-%m-%d’)