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.71k stars 1.58k forks source link

Importing sql did not bring comments here #184

Closed whrss9527 closed 3 months ago

whrss9527 commented 3 months ago
image

Importing sql did not bring comments here

image
Nitiksharma2001 commented 3 months ago

can you please share a video about the issue..?

whrss9527 commented 3 months ago

The thing is this. After I started it locally, I selected to import the sql source file in the upper left corner, and then selected a mysql sql file to import it. The format is like this:

CREATE TABLE IF NOT EXISTS `game`
(
    `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '自增 ID',
    `game_id` varchar(32) NOT NULL COMMENT '游戏 ID'
    PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'xxx';

Then after importing, the original 'comment' is not brought in and is displayed as 'Not Set'