Recently I've been looking into export options to find an option to remove:
DROP TABLE IF EXISTS and replace it with
CREATE TABLE IF NOT EXISTS.
It's very dangerous as usually when exporting and importing to exchange data with other tables, it simply DROPS tables when they exist rather then just updating them.
I've did research about the issue, and all I'm getting is an explanation about drop table method itself.
I've been using MySQL Workbench for quite sometime, and now I'm really thinking to switch to another MySQL client because of this.
Im using MySQL Workbench Community edition version 8.0.12.
Thanks in advance.