Answer the question
In order to leave comments, you need to log in
Why is mysql query not working in nodejs?
Such a query does not work (no errors occur, but nothing changes in the database):
db.query("UPDATE Statistics SET online='" + Online + "', maximumOnline='" + MaximumOnline + "' WHERE date='" + new Date(CurrentStatisticsTime).toISOString() + "'");
db.query("INSERT INTO Statistics (date, online, maximumOnline) VALUE ('" + new Date(CurrentStatisticsTime).toISOString() + "','" + Online + "','" + MaximumOnline + "')");
db.query("SELECT * FROM Statistics WHERE date='" + new Date(CurrentStatisticsTime).toISOString() + "'");
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question