Operate MySQL databases using golang

Package main

Import "database/SQL"
Import _ "github.com/go-sql-driver/mysql"
Import "FMT"

Func checkerr (ERR error ){
If Err! = Nil {
FMT. println (ERR)
Panic (ERR)
}
}

Func main (){
DB, err: = SQL. Open ("MySQL", "root: dumx @/test? Charset = utf8 ")
Checkerr (ERR)

Stmt, err: = dB. Prepare ("insert test. latlng set lat = ?, Lng =? ")
Checkerr (ERR)

Res, err: = stmt. Exec ("123", "456 ")
Checkerr (ERR)

ID, err: = res. lastinsertid ()
Checkerr (ERR)

FMT. println (ID)

// Update database
Stmt, err = dB. Prepare ("Update test. latlng set lat =? ")
Checkerr (ERR)

Res, err = STS. Exec ("789 ")
Checkerr (ERR)

Affect, err: = res. rowsaffected ()
Checkerr (ERR)

FMT. println (affect)
// Query data
Rows, err: = dB. Query ("select * from test. latlng ")
Checkerr (ERR)

For rows. Next (){
VaR Lat, LNG int
Err = rows. Scan (& lng, & LAT)
Checkerr (ERR)
FMT. println ("Lat:", Lat)
FMT. println ("LNG:", LNG)
}
}