sTfLVTgp

1下载：
2
3```shell
4go get -tags 'mysql' -u -v github.com/golang-migrate/migrate/cmd/migrate
5```
6
7创建名称为 test 的数据库：
8
9```
10create database test;
11```
12
13创建第一个 migration
14
15```shell
16mkdir migrations
17migrate create -ext=sql -dir=migrations -seq init
18```
19
20编辑 migration/000001_init.up.sql
21
22```sql
23CREATE TABLE IF NOT EXISTS `users`(
24   `user_id` serial PRIMARY KEY,
25   `username` VARCHAR (50) UNIQUE NOT NULL,
26   `password` VARCHAR (50) NOT NULL,
27   `email` VARCHAR (300) UNIQUE NOT NULL
28);
29```
30
31编辑 migration/000001_init.down.sql
32
33```sql
34drop table if exists `users`;
35```
36
37migrate 
38
39```shell
40migrate -path=./migration -database="mysql://root:root@tcp(127.0.0.1:3306)/test" up
41```
42
43ok！