#create new mysql table very quickly using brief yaml config.
npm i tablequick -g
tablequick config
then you will got a mysql-config.json
here fill out the .json file so we can connect to your database.
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
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;
| 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 |