首先，在mysql數(shù)據(jù)庫中建立一張表:

CREATE TABLE `t_test` (`id` int(11) NOT NULL AUTO_INCREMENT,`age` int(11) DEFAULT '0',`name` varchar(32) COLLATE utf8_bin DEFAULT NULL,PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

// 需要先安裝: go get github.com/go-sql-driver/mysqlpackage mainimport ("database/sql""fmt"_ "github.com/go-sql-driver/mysql" )func main() {db, err := sql.Open("mysql", "root:123@tcp(192.168.10.15:3306)/gamedata_tian?charset=utf8")if err != nil {fmt.Println(err)return}defer db.Close()var result sql.Resultresult, err = db.Exec("insert into t_test(age, name) values(?,?)", 13, "joe")if err != nil {fmt.Println(err)return}lastId, _ := result.LastInsertId()fmt.Println("新插入記錄的ID為", lastId)var row *sql.Rowrow = db.QueryRow("select * from t_test")var name stringvar id, age interr = row.Scan(&id, &age, &name)if err != nil {fmt.Println(err)return}fmt.Println(id, "\t", name, "\t", age)result, err = db.Exec("insert into t_test(age, name) values(?,?)", 24, "black")var rows *sql.Rowsrows, err = db.Query("select * from t_test")if err != nil {fmt.Println(err)return}for rows.Next() {var name stringvar id, age introws.Scan(&id, &age, &name)fmt.Println(id, "\t", name, "\t", age)}rows.Close()db.Exec("truncate table t_test") }

總結(jié)

以上是生活随笔為你收集整理的go连接mysql数据库的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。