golang下载mysql_golang 操作mysql

1 数据库表

CREATE TABLE `users` (

`id` int(10) UNSIGNED NOT NULL,

`name` varchar(25) NOT NULL,

`age` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--

-- 转存表中的数据 `users`

--

INSERT INTO `users` (`id`, `name`, `age`) VALUES

(1, '张三', 25),

(2, '李四', 22),

(3, '田七', 25);

2 连接数据库

mysql.go

package dbs

import (

"database/sql"

"fmt"

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

"log"

"time"

)

var MysqlDb *sql.DB

var MysqlDbErr error

const (

USER_NAME = "root"

PASS_WORD = "root"

HOST = "localhost"

PORT = "3306"

DATABASE = "demo"

CHARSET = "utf8"

)

// 初始化链接

func init() {

dbDSN := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=%s", USER_NAME, PASS_WORD, HOST, PORT, DATABASE, CHARSET)

// 打开连接失败

MysqlDb, MysqlDbErr = sql.Open("mysql", dbDSN)

//defer MysqlDb.Close();

if MysqlDbErr