1.新建项目

2.添加mysql数据库依赖

 <dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency>

pom.xml如下所示

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.3.0.RELEASE</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>com.springboot</groupId><artifactId>my_flyway</artifactId><version>0.0.1-SNAPSHOT</version><name>my_flyway</name><description>Demo project for my_flyway</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter</artifactId></dependency><dependency><groupId>org.flywaydb</groupId><artifactId>flyway-core</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope><exclusions><exclusion><groupId>org.junit.vintage</groupId><artifactId>junit-vintage-engine</artifactId></exclusion></exclusions></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>

3.配置application.properties

## 设定 db source 属性
spring.datasource.url=jdbc:mysql://localhost:3306/flyway?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456## 设定 flyway 属性
#spring.flyway.cleanDisabled = false
# flyway 的 clean 命令会删除指定 schema 下的所有 table, 杀伤力太大了, 应该禁掉.
#spring.flyway.enabled = true
# 启用或禁用 flyway
spring.flyway.locations =classpath:db/migration
# 设定 SQL 脚本的目录,多个路径使用逗号分隔, 比如取值为 classpath:db/migration,filesystem:/sql-migrations
#spring.flyway.baselineOnMigrate=true
# 如果指定 schema 包含了其他表,但没有 flyway schema history 表的话, 在执行 flyway migrate 命令之前, 必须先执行 flyway baseline 命令.
# 设置 spring.flyway.baseline-on-migrate 为 true 后, flyway 将在需要 baseline 的时候, 自动执行一次 baseline.
#spring.flyway.baselineVersion=1
# 指定 baseline 的版本号,缺省值为 1, 低于该版本号的 SQL 文件, migrate 的时候被忽略.
#spring.flyway.encoding=
# Encoding of SQL migrations (default: UTF-8)
#spring.flyway.table=flyway_schema_history_myapp
# 设定 flyway 的 metadata 表名, 缺省为 flyway_schema_history
spring.flyway.outOfOrder=true
# 开发环境最好开启 outOfOrder, 生产环境关闭 outOfOrder .
#spring.flyway.schemas=
# 需要 flyway 管控的 schema list, 缺省的话, 使用的时 dbsource.connection直连上的那个 schema, 可以指定多个schema, 但仅会在第一个schema下建立 metadata 表, 也仅在第一个schema应用migration sql 脚本. 但flyway Clean 命令会依次在这些schema下都执行一遍.

4.添加sql文件

/*Navicat Premium Data TransferSource Server         : localhostSource Server Type    : MySQLSource Server Version : 80019Source Host           : localhost:3306Source Schema         : testTarget Server Type    : MySQLTarget Server Version : 80019File Encoding         : 65001Date: 24/05/2020 09:35:26
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for person
-- ----------------------------
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person`  (`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,`age` int(0) NOT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '人员信息表' ROW_FORMAT = Dynamic;-- ----------------------------
-- Records of person
-- ----------------------------
INSERT INTO `person` VALUES (1, 'zhangjie', 32);
INSERT INTO `person` VALUES (2, 'zhangqin', 27);SET FOREIGN_KEY_CHECKS = 1;

5.启动项目

打印日志如下所示：

D:\software\java\jdk_1.8\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=63821 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Djava.rmi.server.hostname=localhost -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\software\idea\IntelliJ IDEA 2018.3.1\lib\idea_rt.jar=63822:D:\software\idea\IntelliJ IDEA 2018.3.1\bin" -Dfile.encoding=UTF-8 -classpath D:\software\java\jdk_1.8\jre\lib\charsets.jar;D:\software\java\jdk_1.8\jre\lib\deploy.jar;D:\software\java\jdk_1.8\jre\lib\ext\access-bridge-64.jar;D:\software\java\jdk_1.8\jre\lib\ext\cldrdata.jar;D:\software\java\jdk_1.8\jre\lib\ext\dnsns.jar;D:\software\java\jdk_1.8\jre\lib\ext\jaccess.jar;D:\software\java\jdk_1.8\jre\lib\ext\jfxrt.jar;D:\software\java\jdk_1.8\jre\lib\ext\localedata.jar;D:\software\java\jdk_1.8\jre\lib\ext\nashorn.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunec.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunjce_provider.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunmscapi.jar;D:\software\java\jdk_1.8\jre\lib\ext\sunpkcs11.jar;D:\software\java\jdk_1.8\jre\lib\ext\zipfs.jar;D:\software\java\jdk_1.8\jre\lib\javaws.jar;D:\software\java\jdk_1.8\jre\lib\jce.jar;D:\software\java\jdk_1.8\jre\lib\jfr.jar;D:\software\java\jdk_1.8\jre\lib\jfxswt.jar;D:\software\java\jdk_1.8\jre\lib\jsse.jar;D:\software\java\jdk_1.8\jre\lib\management-agent.jar;D:\software\java\jdk_1.8\jre\lib\plugin.jar;D:\software\java\jdk_1.8\jre\lib\resources.jar;D:\software\java\jdk_1.8\jre\lib\rt.jar;D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway\target\classes;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter\2.3.0.RELEASE\spring-boot-starter-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot\2.3.0.RELEASE\spring-boot-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-context\5.2.6.RELEASE\spring-context-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-aop\5.2.6.RELEASE\spring-aop-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-expression\5.2.6.RELEASE\spring-expression-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-autoconfigure\2.3.0.RELEASE\spring-boot-autoconfigure-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter-logging\2.3.0.RELEASE\spring-boot-starter-logging-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\document\eclipse_workspace\local_repository\local_repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.2\log4j-to-slf4j-2.13.2.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\apache\logging\log4j\log4j-api\2.13.2\log4j-api-2.13.2.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\document\eclipse_workspace\local_repository\local_repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-core\5.2.6.RELEASE\spring-core-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-jcl\5.2.6.RELEASE\spring-jcl-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\flywaydb\flyway-core\6.4.1\flyway-core-6.4.1.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.0.RELEASE\spring-boot-starter-jdbc-2.3.0.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-jdbc\5.2.6.RELEASE\spring-jdbc-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-beans\5.2.6.RELEASE\spring-beans-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\org\springframework\spring-tx\5.2.6.RELEASE\spring-tx-5.2.6.RELEASE.jar;D:\document\eclipse_workspace\local_repository\local_repository\mysql\mysql-connector-java\8.0.20\mysql-connector-java-8.0.20.jar com.springboot.my_flyway.MyFlywayApplication.   ____          _            __ _ _/\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \\\/  ___)| |_)| | | | | || (_| |  ) ) ) )'  |____| .__|_| |_|_| |_\__, | / / / /=========|_|==============|___/=/_/_/_/:: Spring Boot ::        (v2.3.0.RELEASE)2020-05-24 12:15:55.447  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : Starting MyFlywayApplication on LAPTOP-SRJM9GEI with PID 19064 (D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway\target\classes started by 张琴 in D:\搜狗高速下载\flyway-springboot-master\flyway-springboot-master\my_flyway)
2020-05-24 12:15:55.449  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : No active profile set, falling back to default profiles: default
2020-05-24 12:15:55.968  INFO 19064 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 6.4.1 by Redgate
2020-05-24 12:15:55.975  INFO 19064 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-05-24 12:15:56.712  INFO 19064 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2020-05-24 12:15:56.736  INFO 19064 --- [           main] o.f.c.internal.database.DatabaseFactory  : Database: jdbc:mysql://localhost:3306/flyway (MySQL 8.0)
2020-05-24 12:15:56.768  INFO 19064 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 1 migration (execution time 00:00.012s)
2020-05-24 12:15:56.783  INFO 19064 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Creating Schema History table `flyway`.`flyway_schema_history` ...
2020-05-24 12:15:56.863  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema `flyway`: << Empty Schema >>
2020-05-24 12:15:56.863  WARN 19064 --- [           main] o.f.core.internal.command.DbMigrate      : outOfOrder mode is active. Migration of schema `flyway` may not be reproducible.
2020-05-24 12:15:56.874  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `flyway` to version 20200524.09.35 - V1.0 person
2020-05-24 12:15:56.890  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Unknown table 'flyway.person' (SQL State: 42S02 - Error Code: 1051)
2020-05-24 12:15:56.925  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Integer display width is deprecated and will be removed in a future release. (SQL State: HY000 - Error Code: 1681)
2020-05-24 12:15:56.925  WARN 19064 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: Integer display width is deprecated and will be removed in a future release. (SQL State: HY000 - Error Code: 1681)
2020-05-24 12:15:56.954  INFO 19064 --- [           main] o.f.core.internal.command.DbMigrate      : Successfully applied 1 migration to schema `flyway` (execution time 00:00.097s)
2020-05-24 12:15:57.018  INFO 19064 --- [           main] c.s.my_flyway.MyFlywayApplication        : Started MyFlywayApplication in 1.862 seconds (JVM running for 3.103)
2020-05-24 12:15:57.023  INFO 19064 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2020-05-24 12:15:57.027  INFO 19064 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.Process finished with exit code 0

查看数据多了2张表