I am using a mysql pool here and I did a query inside of a query. This is supposed to save the guildowner ID in the database when this command is run. Unfortunately it does not let me run this code for some reason. I listed the error down below. Error: Answer The largest integer value allowed in mySQL int
Tag: node.js
How to connect an existing nodejs server app to Azure SQL database
Can anyone please advise: I have an existing nodejs server running on azure, running node 10.14 on Linux. The project code is on github and when I push changes they are automatically pushed to azure. …
What is the correct syntax for replacements within a SQL string
I am attempting to do a basic search in my sqlite3 database with this JavaScript: This works but is vulnerable to SQL injection. I am trying to get the sqlite replacements parameter to work but I cannot get the syntax right. Sqlite doesn’t want to replace anything within the string literal. What is the …
How to run SQL query with inside a javascript loop(map)?
what I’m trying to do is: loop through array of objects using map function run multiple SQL queries according to object append result of queries with object I’m looping through offers which is array of object.I get free_item and buy_item which are associated with offer.I am using knexjs for postgr…
mysql table AUTO increment keeps incrementing in steps of instead of 1. Like 41,51,61
Even after deleting all rows in the table continues. It continues adding from the last inserted id. I used this to create my table adding users with a signup route and it keeps incrementing in steps of 10 this is the code that is used the 10 rows of json data Answer That’s normal behavior of MySQL and o…
Select row by user_id and any row which share that entry’s event_id
I have a table which includes the following format: _______________________________ | event_id | user_id | username | |——————————-| | 30 | 1 | user1 | | 30 | …
Nodejs and SQL – Issue with inserting data to SQL using multiple select statements
Error image While inserting the data in SQL database table user_recipe_consumption by using multiple select statements i am facing error as – throw err; // Rethrow non-MySQL errors ^ Error: …
How to make a workable SQL request for NodeJS file?
I have a js file to work with my local database, and a POST request is not working like it should – if I enter a specific row, it returns a correct result, but I need it to get the variable from post data. This type of entering query doesn’t work 🙁 Answer You can try to use the “Prepared
Join my app database with database from software
I have been hurting a wall for quite a while now, I am making an application linked to a software that we are using, which will allow the user to either access data from the software with my application and update data with my application on the software. So here is the whole idea: So my app will be linked
Multi-parameter search with mysql and node.js
Let me preface by saying I’m very new to SQL (and back end design) in general. So for those annoyed with noob questions, please be gentle. BACKGROUND: I’m trying to build a product test database (storing test data for all our products) where I want a user to be able to refine a search to find test…