0
Fixed

SQL export with tables+pk error

taartaar 5 years ago updated by Support 5 years ago 3

When only create schema, create table and create primary key are selected and a table has a foreign key, the exported SQL contains a syntax error. There is a comma after the  primary key definition looking like this:

CREATE TABLE `Users`
(
`ID` INT NOT NULL AUTO_INCREMENT ,

PRIMARY KEY (`ID`), <-- this comma is a syntax error
-- SKIP: `fkIdx_202`
);
GOOD, I'M SATISFIED
Satisfaction mark by taartaar 5 years ago