Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +-----+------------+
- | no | nama |
- +-----+------------+
- | 001 | Example |
- +-----+------------+
- MySQL username: golang
- MySQL password: cobadatabase
- func main() {
- /* Ini konekin database-nya dulu */
- app_database, err := sql.Open("mysql", "golang:cobadatabase@tcp(192.168.102.175:3360)/example")
- /* Nah klo ini Error Handling */
- if err != nil {
- log.Fatal(err) // informasi log jika koneksi database gagal
- }
- defer app_database.Close() // Close koneksi jika benar-benar gagal
- /* End of Error Handling Connection */
- var (
- no string
- nama string
- )
- baris, err := app_database.Query("SELECT * FROM example_table")
- if err != nil {
- log.Fatal(err)
- }
- defer baris.Close()
- for baris.Next() {
- err := baris.Scan(&no, &nama)
- if err != nil {
- log.Fatal(err)
- }
- log.Println(no, nama)
- }
- err = baris.Err()
- if err != nil {
- log.Fatal(err)
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement