Issues with MySQL import

Ask the Community
1

The MySQL import function works, but it does not seem to support certain things that are reasonably common in MySQL schema dumps, like the following:

*UNSIGNED integers.

  • Chained ALTER TABLE statements, like this:
    ALTER TABLE foo
    ADD COLUM foo VARCHAR,
    ADD COLUMN bar VARCHAR;
  • ALTER TABLE ADD UNIQUE KEY
  • ALTER TABLE MODIFY
  • ALTER TABLE ADD CONSTRAINT

So in general it boils down to issues with the variants on ALTER TABLE, and using UNSIGNED integers.