Support reserved keywords and events in MySQL 8.0
dbForge Studio 2019 for MySQL 8.1.22
When sync data between MySQL 5.7.25 and MySQL 8.0.15 and table have field name in reserver keywords, got error like "check syntax ", rank,", fields and tables names must be enclosed in apostrophes.
MySQL 8.0 event like
CREATE
DEFINER = 'username'@'localhost'
EVENT odatabase.eventname
ON SCHEDULE EVERY '1' WEEK
...
in GUI shows as "every '7' (SEVEN) weeks", but DDL is right.
1
vote
Sergey
shared this idea
-
Sergey commented
as sync i mean compare data