Redgate Flyway

Verified Versions: 5.5, 8.0
Maintainer: Redgate

Supported Versions and Support Levels

For information regarding the supported version and support levels available, please see Supported Databases for Flyway
For information regarding the Flyway features available, please see Flyway feature summary

Drivers

Item	Details
URL format	`jdbc:mysql://instance.region.rds.amazonaws.com:port/database?usePipelineAuth=false&useBatchMultiSend=false` aws-advanced-jdbc-wrapper: `jdbc:aws-wrapper:mysql://instance.region.rds.amazonaws.com:port/database?usePipelineAuth=false&useBatchMultiSend=false`
SSL support	Yes - add `?useSsl=true`
Ships with Flyway Command-line	No
Maven Central coordinates	`mysql:mysql-connector-java`
Supported versions	`8.0.12` and later
Default Java class	`com.mysql.jdbc.Driver` aws-advanced-jdbc-wrapper: `software.amazon.jdbc.Driver`

Note the additional parameters in the connection string, see About MariaDB ConnectorJ for details on Aurora compatibility. aws-advanced-wrapper support is a community addition and not maintained by Redgate

SQL Script Syntax

Standard SQL syntax with statement delimiter ;
Delimiter change for stored procedures using DELIMITER statements
Comment directives generated by mysqldump (/!.../;)
MySQL-style single-line comments (# Comment)

Compatibility

DDL exported by mysqldump can be used unchanged in a Flyway migration.
Any MySQL SQL script executed by Flyway, can be executed by the MySQL command-line tool and other MySQL-compatible tools (after the placeholders have been replaced).

Example

/* Single line comment */
CREATE TABLE test_data (
 value VARCHAR(25) NOT NULL,
 PRIMARY KEY(value)
);

/*
Multi-line
comment
*/

-- MySQL procedure
DELIMITER //
CREATE PROCEDURE AddData()
 BEGIN
   # MySQL-style single line comment
   INSERT INTO test_data (value) VALUES ('Hello');
 END //
DELIMITER;

CALL AddData();

-- MySQL comments directives generated by mysqlsump
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');

Limitations

Issue 558 The parser currently doesn't support multiple comment directives on a single line.
Example: /!50003 CREATE/ /!50017 DEFINER=.../ /*!50003 TRIGGER EntityBeforeInsert ...