Using prepared statements & pointers in Golang
I changed the name of this blog to “a study of bugs”. This makes it easier for me to think of what to write about -- bugs, of course.
In MySQL, you can use a question mark (?) in a prepared statement to stand in for a value.
In the Go code above,
dbconn is a connection to a MySQL server. Line 1 defines a prepared statement. And Line 3 queries the table for a row where the
name column matches the value of variable
name. I assumed the
? in this query would be interpolated with an actual string. I added quotation marks since they are needed around strings in MySQL CLI. ⋯