Created
February 7, 2025 14:08
-
-
Save Saharayama/7d56de18a2e7bf97a4103f8c32e7e46b to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "database/sql" | |
| "fmt" | |
| "log" | |
| _ "github.com/go-sql-driver/mysql" | |
| ) | |
| func main() { | |
| // データベースに接続 | |
| db, err := sql.Open("mysql", "ユーザー名:パスワード@tcp(ホスト名:ポート番号)/データベース名") | |
| if err != nil { | |
| log.Fatal(err) | |
| } | |
| defer db.Close() | |
| // クエリを実行 | |
| rows, err := db.Query("SELECT id, name FROM users") | |
| if err != nil { | |
| log.Fatal(err) | |
| } | |
| defer rows.Close() | |
| // 結果を処理 | |
| for rows.Next() { | |
| var id int | |
| var name string | |
| err := rows.Scan(&id, &name) | |
| if err != nil { | |
| log.Fatal(err) | |
| } | |
| fmt.Println(id, name) | |
| } | |
| // エラーチェック | |
| err = rows.Err() | |
| if err != nil { | |
| log.Fatal(err) | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment