All Questions
Tagged with javascript mysql
6 questions
0
votes
1
answer
112
views
Is it really possible to use SQL injection to change a database, or is this a scam?
A guy I know at college is claiming he can change his grades by gaining access to the database through an SQL inject, and can also gain access to all admin account privileges and records. The portal ...
- 11
1
vote
0
answers
554
views
Converting Mongoose schema to Prisma Mysql schema
I am trying to convert the following Mongoose schema to a Prisma MySql Schema. Not sure if I am doing it right. Here is the Mongoose Schema:
import mongoose from 'mongoose';
const { ObjectId } = ...
- 111
0
votes
0
answers
150
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
...
- 1
0
votes
1
answer
1k
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 ...
-1
votes
1
answer
28
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
...
0
votes
1
answer
102
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: '...
- 101