#create new mysql table very quickly using brief yaml config.

Step 1: Install globally

npm i tablequick -g

Step 2: create and edit a mysql file to connect to mysql

tablequick config

then you will got a mysql-config.json here fill out the .json file so we can connect to your database.

Step 3:

so if you want create a table named "students" and include fields: "student_code","gender","register_time"

first create a yaml file with the name of table:

touch students.yaml

students.yaml

student_code: $$i
name: c100
gender: c6
register_time: t

then process this file using tablequick

tablequick create students

result:

now you got a perfect students table like this, just with a very brief .yaml config file! student_code | name | gender | register_time -|-|-|- 1|wanthering|male|2018-06-27 14:51:31

the mysql input is :

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `students`;
create table `students`(
DROP TABLE IF EXISTS `students`;
create table `students`(
`student_code` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`gender` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
`register_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;

Converting Rules:

yaml input| sql output -|- $| PRIMARY KEY $$| AUTO_INCREMENT PRIMARY KEY i|int i100|int(100) NOT NULL c|varchar COLLATE utf8mb4_unicode_ci NOT NULL c100|varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL t|timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP x-> y | KEY y(x) USING BTREE