Importing schemas for MySQL

#1

I can’t import table schema for MySQL. The message is: “Error: could not parse create table statement.”
I got the schema from SQLyog and it looks like this:
CREATE TABLE examination (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL DEFAULT ‘’,
description varchar(512) NOT NULL DEFAULT ‘’,
examination_type_id int(11) NOT NULL DEFAULT ‘0’,
laboratory_id int(11) NOT NULL DEFAULT ‘0’,
order_by int(11) NOT NULL DEFAULT ‘0’,
active tinyint(4) NOT NULL DEFAULT ‘1’,
timestamping timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
)

I would pay for this to work, it causes me so much time waste to enter the fields one by one

#2

You are using MySQL, while it looks like that Mockaroo only supports PostgreSQL. You can convert your MySQL script with this online tool http://www.sqlines.com/online into this:

CREATE SEQUENCE examination_seq;

CREATE TABLE examination (
id int NOT NULL DEFAULT NEXTVAL ('examination_seq'),
name varchar(255) NOT NULL DEFAULT '',
description varchar(512) NOT NULL DEFAULT '',
examination_type_id int NOT NULL DEFAULT '0',
laboratory_id int NOT NULL DEFAULT '0',
order_by int NOT NULL DEFAULT '0',
active smallint NOT NULL DEFAULT '1',
timestamping timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
)

Omit the first line and copy paste the other into Mockaroo will let you create your Schema. (You will get another error, but the schema is created anyway.)

You can find the result here: https://www.mockaroo.com/10b8b8f0

#3

Thanks man, this solved my problem!