Golang database/sql.NullString type example
package database/sql
NullString represents a string that may be null. NullString implements the Scanner interface so it can be used as a scan destination:
Golang database/sql.NullString type usage example
Example 1: ( from http://golang.org/pkg/database/sql/#NullString )
var s NullString
err := db.QueryRow("SELECT name FROM foo WHERE id=?", id).Scan(&s)
...
if s.Valid {
// use s.String
} else {
// NULL value
}
Example 2:
var num int
var text string
var blob []byte
var nothing sql.NullString
err = txn.QueryRow("SELECT * FROM temp").Scan(&num, &text, &blob, ¬hing)
if err != nil {
t.Fatal(err)
}
Reference :
Advertisement
Something interesting
Tutorials
+12.9k Golang : Verify token from Google Authenticator App
+5.1k PHP : Convert CSV to JSON with YQL example
+15.6k Golang : How to check if input from os.Args is integer?
+20.9k Golang : Convert string slice to struct and access with reflect example
+8.6k Golang : How to find out similarity between two strings with Jaro-Winkler Distance?
+14.8k Golang : Get query string value on a POST request
+8.2k Golang : Convert(cast) []byte to io.Reader type
+5k Golang : If else example and common mistake
+42.1k Golang : Convert []byte to image
+27.7k Get file path of temporary file in Go
+26.6k Golang : dial tcp: too many colons in address