Error parsing create table statement

#1

I went into https://mockaroo.com/schemas/create_from_ddl and pasted the following create table statement:

CREATE TABLE users ( id INT(11) NOT NULL AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, email VARCHAR(100) NOT NULL, PRIMARY KEY (id) );

Every time, no matter how much I try to edit the statement, results with an error: Error: could not parse create table statement.

Does Mockaroo require the statements to be written in a specific way, and if so, what’s the correct syntax? I would imagine it supports at least MySQL and/or Postgres types

1 Like
#2

Other variations of the statements that I have tried…

indicate SQL engine & COLLATE types:

CREATE TABLE users ( id INT(11) NOT NULL AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci', last_name VARCHAR(50) NOT NULL COLLATE 'utf8_unicode_ci', email VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci' PRIMARY KEY (id) ) COLLATE='utf8_unicode_ci' ENGINE=InnoDB;