当有在项目启动时先执行指定的sql语句的需求时,可以在
resources
文件夹下添加需要执行的sql
文件,文件中的sql
语句可以是DDL
脚本或DML
脚本,然后在配置加入相应的配置即可,如下:spring: datasource: url: jdbc:mysql://127.0.0.1:3306/spring-boot-demo?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=GMT%2B8 username: root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver type: com.zaxxer.hikari.HikariDataSource initialization-mode: always continue-on-error: true schema: - "classpath:db/schema.sql" data: - "classpath:db/data.sql"