Skip to content

Instantly share code, notes, and snippets.

@raismaulana
Created September 23, 2022 06:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save raismaulana/a82d3a7505121c867615f75fcf1535cf to your computer and use it in GitHub Desktop.
Save raismaulana/a82d3a7505121c867615f75fcf1535cf to your computer and use it in GitHub Desktop.
unsafe_column_query.go
func query(db *sql.DB, orderBy []string) {
query := fmt.Sprint("select id, name, grade from students ")
paging := ""
if len(opt.OrderBy) > 0 {
paging += `ORDER BY ` + strings.Join(orderBy, ",") + ` `
}
query = query + paging
_, err := db.Query(query)
if err != nil {
fmt.Println(err.Error())
return
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment