I’ve used Amazon SCT to convert schema from Oracle to Mariadb. However, with the output of SQL file from Amazon SCT. I directly let liquibase do the operation.
And then i encounter the error.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'delimiter //
CREATE DATABASE IF NOT EXISTS ITOP' at line 1
here’s my sql.
delimiter //
-- ------------ Write DROP-OTHER-stage scripts -----------
USE `IPOP`;//
set sql_mode = ORACLE;//
and with this sqlfile, i execute with the sql cli, it works.