【汇智学堂】docker+springboot+mysql之一（数据准备）
一、data
New DataBase a in Navicat.
run a.sql in database a.
a.sql:
DROP TABLE IF EXISTS user;
CREATE TABLE user (id int(11) NOT NULL AUTO_INCREMENT,username varchar(20) DEFAULT NULL,password varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
– Records of user
INSERT INTO user VALUES (‘1’, ‘leilei’, ‘1234’);
reflush database a