MySQL operation of Golang

said that year fornicated to the computer a crackling,, to MySQL add and delete changes to increase the insert

Package Mainimport ("FMT"    "GITHUB.COM/JMOIRON/SQLX"    _ "Github.com/go-sql-driver/mysql" //To initialize a MySQL driver, you must) Type personstruct{UserIdint' DB:"user_id"' Usernamestring' DB:"username"' Sexstring' DB:"Sex"' Emailstring' DB:"Email"'}type Placestruct{Countrystring' DB:"Country"' Citystring' DB:" City"' Telcodeint' DB:"Telcode"`}varDb *SQLX. Dbfunc init () {//"MySQL" Specifies the database type,/test the specified database root:123 colon-separated password root account 123 PasswordDatabase, err: = Sqlx. Open ("MySQL","[email protected] (127.0.0.1:3306)/test")    ifErr! =Nil {fmt. Println ("Open MySQL failed,", Err)return} Db=Database}func Main () {//inserting data into a tableR, Err: = Db.exec ("INSERT into person (username,sex,email) VALUES (?,?,?)","Chaoge","Mans","[email protected]")    ifErr! =Nil {fmt. Println ("exec failed,", Err)return} ID, err:=R.lastinsertid ()ifErr! =Nil {fmt. Println ("exec failed,", Err)return} fmt. Println ("Insert SUCC:", id)}

InsertQuery Select

Package Mainimport ("FMT"    _ "Github.com/go-sql-driver/mysql"    "GITHUB.COM/JMOIRON/SQLX") Type personstruct{UserIdint' DB:"user_id"'`Usernamestring' DB:"username"' Sexstring' DB:"Sex"' Emailstring' DB:"Email"'}type Placestruct{Countrystring' DB:"Country"' Citystring' DB:" City"' Telcodeint' DB:"Telcode"`}varDb *SQLX. Dbfunc init () {//initializing a linked databaseDatabase, err: = Sqlx. Open ("MySQL","Root: @tcp (127.0.0.1:3306)/test")    ifErr! =Nil {fmt. Println ("Open MySQL failed", Err)return} Db=Database}func Main () {varPerson []person err:= Db.select (&person,"Select User_id,username,sex,email from person where user_id=?",1)    ifErr! =Nil {fmt. Println ("exec failed,", Err)return} fmt. Println ("Select SUCC:", person)}

SelectChange update

Package Mainimport ("FMT"    _ "Github.com/go-sql-driver/mysql"    "GITHUB.COM/JMOIRON/SQLX") Type personstruct{UserIdint' DB:"user_id"' Usernamestring' DB:"username"' Sexstring' DB:"Sex"' Emailstring' DB:"Email"'}type Placestruct{Countrystring' DB:"Country"' Citystring' DB:" City"' Telcodeint' DB:"Telcode"`}varDb *SQLX. Dbfunc init () {database, err:= Sqlx. Open ("MySQL","[email protected] (127.0.0.1:3306)/test")    ifErr! =Nil {fmt. Println ("Open MySQL failed,", Err)return} Db=Database}func Main () {_, Err:= Db.exec ("Update person set username=? where user_id=?","chaoge666",1)    ifErr! =Nil {fmt. Println ("exec failed,", Err)}}

UpdateDelete Delete

Package Mainimport ("FMT"    _ "Github.com/go-sql-driver/mysql"    "GITHUB.COM/JMOIRON/SQLX") Type personstruct{UserIdint' DB:"user_id"' Usernamestring' DB:"username"' Sexstring' DB:"Sex"' Emailstring' DB:"Email"'}type Placestruct{Countrystring' DB:"Country"' Citystring' DB:" City"' Telcodeint' DB:"Telcode"`}varDb *SQLX. Dbfunc init () {//initializing a linked databaseDatabase, err: = Sqlx. Open ("MySQL","[email protected] (127.0.0.1:3306)/test")    ifErr! =Nil {fmt. Println ("Open MySQL failed,", Err)return} Db=Database}func Main () {_, Err:= Db.exec ("Delete from the person where user_id=?",1)    ifErr! =Nil {fmt. Println ("exec failed,", Err)return} fmt. Println ("Delete succ")}

Delete

MySQL operation of Golang