- Database Name : beego
- Tabel Name : ti_test
- Field :
- number, integer(11), primary key not auto increment.
- squareNumber, integer(11)
go get github.com/go-sql-driver/mysql
Pastikan kalian mengetahui username dan password MySQL nya ya, jika sudah silahkan buat file .go bebas, kalo saya hellomysql.go, jika sudah sekarang isikan script golangnya :
package main
import (
“database/sql”
“fmt”
_ “github.com/go-sql-driver/mysql”
)
func main() {
db, err := sql.Open(“mysql”, “username:password@/namadatabase”)
if err != nil {
panic(err.Error()) // Just for example purpose. You should use proper error handling instead of panic
}
defer db.Close()
// Prepare statement for inserting data
stmtIns, err := db.Prepare(“INSERT INTO ti_test VALUES( ?, ? )”) // ? = placeholder
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
defer stmtIns.Close() // Close the statement when we leave main() / the program terminates
// Prepare statement for reading data
stmtOut, err := db.Prepare(“SELECT squareNumber FROM ti_test WHERE number = ?”)
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
defer stmtOut.Close()
// Insert square numbers for 0-24 in the database
for i := 0; i < 25; i++ {
_, err = stmtIns.Exec(i, (i * i)) // Insert tuples (i, i^2)
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
}
var squareNum int // we “scan” the result in here
// Query the square-number of 13
err = stmtOut.QueryRow(13).Scan(&squareNum) // WHERE number = 13
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
fmt.Printf(“The square number of 13 is: %d”, squareNum)
// Query another number.. 1 maybe?
err = stmtOut.QueryRow(1).Scan(&squareNum) // WHERE number = 1
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
fmt.Printf(“The square number of 1 is: %d”, squareNum)
}
Saya tidak menjelaskan perbaris codingnya ya, tapi kalo dibaca pasti paham lah. Maksudnya dari script itu intinya insert ke tabel lalu diselect. Jika sudah sekarang compile .go kalian dengan mengetikan go build namafile.go, jika sudah sekarang di run go run namafile.go.
Oke sekarang kalian liat tabel di MySQL kalian. In punya saya :