goland mysql_Go操作MySQL总结

1.下载驱动包

打开GoLand—>Terminal，输入：go get github.com/go-sql-driver/mysql

2.编写代码

package main

import (

"database/sql"

"fmt"

_ "github.com/go-sql-driver/mysql"

"time"

)

//数据库连接信息

const (

USERNAME = "root"

PASSWORD = "123456"

NETWORK = "tcp"

SERVER = "localhost"

PORT = 3306

DATABASE = "test"

)

//user表结构体定义

type User struct {

Id int `json:"id" form:"id