For MySQL how to set Server SQL Modes for the liquibase client

General Discussion
1

Using Liquibase with MySQL I want to set the sql_mode variable for the liquibase client. Is there a way to do this? I want to be able to set this variable so that liquibase updates can run correctly if a sql_mode needs to be set as a pre-requisite.

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

This is a spin off question from another post I made: Liquibase generate-changelog doesn't work with MySQL - #2 by PJatLiquibase

2

I found the answer.

To set the sql_mode variable for Liquibase, you can add the following property to your liquibase.properties file:

url: jdbc:mysql://localhost/mydb?sessionVariables=sql_mode=''