Golang database/sql.Rows type example
package database/sql
Rows is the result of a query. Its cursor starts before the first row of the result set. Use Next to advance through the rows:
Golang database/sql.Rows type usage example
var (
id int
username string
)
rows, err := db.Query("select id, username from accounts where id = ?", 1)
if err != nil {
log.Fatal(err)
}
defer rows.Close()
for rows.Next() {
err := rows.Scan(&id, &name)
if err != nil {
log.Fatal(err)
}
log.Println(id, name)
}
err = rows.Err()
if err != nil {
log.Fatal(err)
}
Reference :
Advertisement
Something interesting
Tutorials
+17k Golang : Get number of CPU cores
+6.5k Unix/Linux : How to get own IP address ?
+9.7k Golang : Eroding and dilating image with OpenCV example
+9.4k Golang : Find the length of big.Int variable example
+16.4k Golang : Test floating point numbers not-a-number and infinite example
+39k Golang : How to iterate over a []string(array)
+15.2k Golang : Get HTTP protocol version example
+17.9k Golang : Qt image viewer example
+8.3k Golang: Prevent over writing file with md5 hash
+10k Golang : Setting variable value with ldflags
+30.5k Get client IP Address in Go
+10.5k Golang : Generate 403 Forbidden to protect a page or prevent indexing by search engine