"DROP IF EXISTS" does not work

oddnoc / silverstripe-artefactcleaner

Find and optionally delete disused tables and fields in a SilverStripe database.

Other

12 stars 5 forks source link

"DROP IF EXISTS" does not work #10

Closed mikeyc7m closed 3 years ago

mikeyc7m commented 3 years ago

I found that columns and indexes could not be processed, the SQL failed because of the IF EXISTS clause. Apparently the syntax is not supported in MySQL.

Simple fix was to remove the clause and it worked fine.

oddnoc commented 3 years ago

Can you provide details of your MySQL version?

mikeyc7m commented 3 years ago

I'm using 5.6.17

oddnoc commented 3 years ago

Fixed in 4.0.2. Thanks!