Inserting a variable into MySQL with Go

Question

I have these 2 variables here

name := request.FormValue("username")
pass := request.FormValue("password")

I want to insert those 2 variables into my database

db.Query("INSERT INTO `godb` (`Username`, `Password`) VALUES (   )")

I tried (name,pass) ('name','pass') ($name, $pass) , none of them work.

Hope the question is not stupid, but I've been looking for solutions online but I did't understand them. Thanks !

Try placeholders: stackoverflow.com/questions/35781555/…. And don't store a raw password into a database, hash and salt it first. — Marc
– Marc, Commented Jun 24, 2020 at 9:56
Note that the language has no support for implicit string interpolation of variables accessible in the current scope, as you seem to expect. You need to pass the variables to the function explicitly. i.e. Query("... VALUES (?, ?)", name, pass). — mkopriva
– mkopriva, Commented Jun 24, 2020 at 10:12

Álvaro González · Accepted Answer · 2020-06-24 09:58:13Z

4

From Using Prepared Statements

Parameter Placeholder Syntax

The syntax for placeholder parameters in prepared statements is database-specific. For example, comparing MySQL, PostgreSQL, and Oracle:
MySQL               PostgreSQL            Oracle
=====               ==========            ======
WHERE col = ?       WHERE col = $1        WHERE col = :col
VALUES(?, ?, ?)     VALUES($1, $2, $3)    VALUES(:val1, :val2, :val3)

You tried PostgreSQL syntax but you use MySQL.

answered Jun 24, 2020 at 9:58

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kazbek Borash · Accepted Answer · 2020-06-24 10:14:52Z

-1

query should be in this format db.Query("INSERT INTO table ($1, $2) VALUES (column1, column2)", value1, value2) in your case something like that db.Query("INSERT INTO godb ($1, $2) VALUES (username, password)", name, pass)

answered Jun 24, 2020 at 10:14

Kazbek Borash

1

1 Comment

mkopriva Over a year ago

This is wrong, not only have you switched the order of columns and values but you are also using the wrong parameter references for mysql.

Collectives™ on Stack Overflow

Inserting a variable into MySQL with Go

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related