search

drawdb-io / drawdb

Free, simple, and intuitive online database diagram editor and SQL generator.
https://drawdb.app
GNU Affero General Public License v3.0
22.74k stars 1.59k forks source link

[BUG] exported sql file contains no column names with mysql or mariaDB as database #233

Closed Martian101 closed 2 months ago

Martian101 commented 2 months ago

Describe the bug sql exported without column names

To Reproduce Steps to reproduce the behavior:

  1. Go to File -> New -> Blank
  2. choose Mysql as Database
  3. create new table and edit the schema
  4. export the edited schema as sql file
  5. See error

Expected behavior export proper sql script file based on the table schema

Screenshots the schema I create for illustration image When try to export the schema as sql, it returns sql script without column names: image

Desktop (please complete the following information):

Additional context The problem only exists when I choose mysql or mariaDB as database, It works perfectly when I choose others.Even the generic database works fine, I can still export to mysql script file.

1ilit commented 2 months ago

Fixed it for mysql but cant reproduce for mariadb

Martian101 commented 2 months ago

Fixed it for mysql but cant reproduce for mariadb

it works both for mysql and mariadb now, thanks !

1ilit commented 2 months ago

Great