본문 바로가기
Programming/Golang

Go언어 - MySQL 연동

by Wilkyway 2020. 12. 6.
반응형

 

package main

import (
	"database/sql"
	"fmt"	

	_ "github.com/go-sql-driver/mysql"
)

func checkError(err error) {
    if err != nil {
        panic(err)
    }
}

func main() {

	var name, email, phone string

	db, err := sql.Open("mysql", "root:1234@tcp(127.0.0.1:3306)/testdb")
	checkError(err)
	defer db.Close()
    
	fmt.Println("connect success")

	rows, err := db.Query("SELECT name, email, phone FROM members where id=?", 6)
	checkError(err)
	defer rows.Close()

	for rows.Next() {
		err := rows.Scan(&name, &email, &phone)
		checkError(err)
		fmt.Println("rows", name, email, phone)
	}
}
반응형

댓글