Go的mysql开发入门
搭好GO开发环境后,获取mysql开发驱动包:go get code.google.com/p/go-mysql-driver/mysql
然后就可以用他进行MSYQL开发了,直接上代码:
package mainimport "fmt"import "database/sql"import _ "code.google.com/p/go-mysql-driver/mysql"func main(){fmt.Printf("query:\n")db,e:= sql.Open("mysql", "root:@/mysql?charset=utf8")//说明:第一个参数"mysql"表示打开一个MYSQL链接//第二个参数是一个DSN,格式是://@]]/dbname[?param1=value1&paramN=valueN]if e != nil {fmt.Printf("conn error.");return;}rows,e := db.Query("select host,user from user")if e != nil {fmt.Printf("query error.");return;}i := 0for rows.Next() {i++var ss,s2 stringe = rows.Scan( &ss,&s2 )if e == nil {fmt.Printf("Title: %s,%s \n", ss,s2 )}else{fmt.Printf("error")}}fmt.Printf("Total: %d\n" , i )db.Close()}
顺便说句,Golang更新到1.0.1了
页:
[1]