You have a syntax error at "test.sql" line 5 column 3. Expected ")" or fields but "K" found.

[calvin2021y]

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 `gid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gid` (`gid`) USING BTREE
);

[calvin2021y]

any one care to comment ?

[TeaNguyen]

I think the SQL should be:

CREATE TABLE `test` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `gid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gid` USING BTREE (`gid`)
);

I tested the above SQL, and it works.

[calvin2021y]

This is a SQL dump by mysqldump.

[calvin2021y]

hi @TeaNguyen

this will not work if you have a lot tables dump my mysql tools. I hope DBML can support mysqldump without extra work.

[calvin2021y]

@TeaNguyen

Mysql also use this:

PRIMARY KEY (`id`) USING BTREE,

DBML can not parse it.

I check with atlas and it work.