golang连接mysql数据库进行查询
1 package main2
3 import (
4 "database/sql"
5 "fmt"
6 _ "github.com/go-sql-driver/mysql"
7 )
8
9 func main() {
10 db, err := sql.Open("mysql", "root:1234567890@/test?")
11 CheckErr(err)
12 rows, err := db.Query("select * from users")
13 CheckErr(err)
14 for rows.Next() {
15 var>
16 var nick string
17 err = rows.Scan(&id, &nick)
18 CheckErr(err)
19 fmt.Println(id)
20 fmt.Println(nick)
21 }
22 db.Close()
23 }
24
25 func CheckErr(err error) {
26 if err != nil {
27 panic(err)
28 }
29 }
页:
[1]