Go语言Mysql简单使用.
发布时间:2020-12-16 09:39:02 所属栏目:大数据 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 查询: package main import ( "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" "time" ) func main() { con,_ := sql.Open("mysql","root:
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考 查询: package main import ( "database/sql" "fmt" _ "github.com/go-sql-driver/mysql" "time" ) func main() { con,_ := sql.Open("mysql","root:[email?protected](localhost:3316)/mysql") defer con.Close() go query(con) time.Sleep(1e9) } func query(con *sql.DB) { Q,_ := con.Prepare("select user,host,password from user where user = ? and host = ?") defer Q.Close() var x,y,z string defer func() { if e := recover(); e != nil { fmt.Println(e) } }() d,_ := Q.Query("root","127.0.0.1") for d.Next() { d.Scan(&x,&y,&z) fmt.Println(z,z) } } 新建: package main import ( "database/sql" //"fmt" _ "github.com/go-sql-driver/mysql" //"time" ) func main() { con,"root:[email?protected](localhost:3316)/test") defer con.Close() P,_ := con.Prepare("CREATE TABLE Test (id int not null AUTO_INCREMENT PRIMARY KEY,name varchar(20) not null)") defer P.Close() P.Exec() } 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |