cd /usr/local/mysql/bin
mysql -u root -p
创建数据库
create database stock;
查询数据库
show stock;
选择数据库
use stock;
创建表
CREATE TABLE table_name (column_name column_type);
删除表
drop table stock_all;
create table stock_all (state_dt varchar(45), stock_code varchar(45),open decimal(20,2),close decimal(20,2),high decimal(20,2),low decimal(20,2),vol int(20),amount decimal(30,2),pre_close decimal(20,2),amt_change decimal(20,2),pct_change decimal(20,2) , primary key(state_dt,stock_code));
查看表
describe stock_all;
插入表数据
insert into stock_all(state_dt,stock_code,open,close,high,low,vol,amount,pre_close,amt_change,pct_change) values(20190725,601330,12.19,12.15,12.25,12.00,136961.64,165811.515,12.24,-0.09,-0.7353);
查询表数据
select * from stock_all;
修改表
1、修改表名:alter table personTable(旧表) rename newpersonTable(新表);
2、增加字段
alter table newpersonTable add sex int;