Re: nodejs/socket.io/mysql

[Rui Quelhas]

Hi Raymond,

glad you found a solution. However, let me elaborate a bit on the problem given what you mention. In this case, the lack of backticks in the table name and column name identifiers is not the issue.

The issue is that you need to "encode" the JavaScript type as a proper MySQL data type that fits the column where you are trying to insert. Which means that by not wrapping the data variable with quotes (single or double) you are basically sending an identifier (and not a literal value) on "VALUES ()" to the server.

So, the issue could be fixed only by replacing

var sql = "insert into room (roomid) values ("+data+");"

with

var sql = "insert into room (roomid) values ('"+data+"');"

or, using template strings:

var sql = `insert into room (roomid) values ('${data}');`