#inserting values in a database with mysql2 — Page 1

night holly Jan 31, 2024, 2:29 PM

So I'm using MySQL2 which is an npm package that allows you to connect to mysql databases.
Basically, I'm trying to add something to the database, however the information which it inputs are stored in a variable. Now, since the way you insert things into the database matters, you have to use specific quotes, so either single quotes, double quotes or backticks. We all know that if you want to put a variable in a string you would do `${varName}`, however, since the query has to be in a string that's made up of single quotes, you can't access that variable. What can I do here? How can I access the variable?

Before you say "replace single quotes with backticks", I tried this and this is the error I get,

const sql = `INSERT INTO test_strikes (username, strike_reason, responsible_instructor) VALUES (${guardNickname}, ${strikeReason}, ${responsibleInstructor})`;

All of those have their own variables defined as strings of letters, and this is the error I get when that's triggered.

carmine frigateBOT Jan 31, 2024, 2:29 PM

Consider reading #how-to-get-help to improve your question!
Explain what exactly your issue is.
Post the full error stack trace, not just the top part!
Show your code!
Issue solved? Press the button!
✅ Marked as resolved by OP

night holly Jan 31, 2024, 2:49 PM

As a point of reference, this is how my database is described;

shut pagoda Feb 1, 2024, 6:57 PM

night holly As a point of reference, this is how my database is described;

Hello, try

const sql = `INSERT INTO test_strikes (username, strike_reason, responsible_instructor) VALUES ('${guardNickname}', '${strikeReason}', '${responsibleInstructor}')`;