Spring Boot项目自动建表插库一、修改application.yml文件二、编写schema.sql和data

一、修改application.yml文件

spring:
  datasource:
    initialization-mode: always # 设置为always后会自动执行schema.sql和data.sql

二、编写schema.sql和data.sql放置于resources下

-- schema.sql用于建表
drop table if exists example;
create table example (
    id INTEGER AUTO_INCREMENT,
    name VARCHAR(128),
    role VARCHAR(128),
    PRIMARY KEY(id)
);

-- data.sql用于插入数据
INSERT INTO payroll VALUES (0, "Bilbo Baggins", "burglar");
INSERT INTO payroll VALUES (0, "Frodo Baggins", "thief");