Docker运行MySql,Navicat、VsCode连接MySql并执行增删改查

apt-get updateapt-get install vim

root@容器id:/etc/mysql# ls
conf.d my.cnf my.cnf.fallback mysql.cnf mysql.conf.d

此处参考链接：MySQL的sql_mode模式说明及设置

重启MySql容器：docker restart 容器id

create table employee(
  id int,
  name varchar(40),
  sex varchar(4),
  birthday date,
  entry_date date,
  salary decimal(8,2),
  resum text
);

insert into employee(id,name,sex,birthday,entry_date,salary,resum)
values(1,'zhangsan','male','1993-03-04','2016-11-10','1000','i am a developer');