Questions tagged [javascript]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
27 views

Generate report by cross join between two tables

I wanted to generate report between two tables by using CROSS JOIN. Below shows the details of table. Table 1: kod_jawatan jawatan_id jawatan_kod jawatan_nama Table 2: tpermohonan mohon_id ...
0
votes
1answer
36 views

Best way for processing over 150 million rows MySql

I wrote a function on nodejs to SELECT 150 million records, process the data and UPDATE those same 150 million records using UPDATE 'table' SET value1='somevalue' WHERE idRo2 = 1; Single Update for ...
0
votes
0answers
11 views

Append object to document node.js/mongodb

Say I have a mongodb document I'm trying to update. The schema is level1 (object)> level2 (object) > "objects". If I want to add another object to the end, what is the method to do ...
-1
votes
1answer
23 views

How to get applied stored procedure for inserted row in mysql php query [closed]

$query = "CREATE PROCEDURE IF NOT EXISTS Insertion(IN firstname varchar(40),IN lastname varchar(40),IN email varchar(40),IN department varchar(40),IN doj date,IN basicpay int(11)) BEGIN ...
1
vote
1answer
427 views

Not authorized on test to execute command

Here is my code: mongoose.connect(consts.database, { useNewUrlParser: true, useUnifiedTopology: true, sslCA: consts.databaseCert, }); //... const user = await db.userModel.findOne({ ...
0
votes
0answers
45 views

Non RAM based in-browser database solutions?

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based ...
0
votes
0answers
15 views

How do I pass organized subsets of data to java-script efficiently?

Disclaimer: I'm a newb to sql, And This is a more general question than I would prefer to ask. So I have a table with a list of English words and a column labeled votes with a bigint value ...
0
votes
1answer
63 views

How to parse MongoDB int32 in node.js

I am using MongoDB for a discord bot I am working on, and I want to retrieve a user's balance. My current code is function findBalance(id){ MongoClient.connect(url, function(err, db) { if (err) throw ...
0
votes
1answer
2k views

Trouble connecting to local MongoDB server through app.js

I'm a newbie to MongoDB, and I just set up MongoDB within my Ubuntu terminal with mongod and mongo commands running in separate terminals. However, I can't get my app.js that would launch a website to ...
0
votes
1answer
33 views

Migrating timezone timestamps

I am trying to migrate this node library https://github.com/LocalSEOGuide/lighthouse-reporter from Postgres to MySQL and getting an error error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '...