Can someone provide a delete query to delete older records(older than 5 days)for the below mysql tables with references, without corrupting my existing data.
I have no clue to write a coordinated delete query (deleting multiple tables in same query)
Why sqlite isn't a server and every dbms else is a server ?
Why we need do start this server and stop
Why mysql isn't just files
but i get this error:
mysql 8.0, not 8.9
any help
This is my model.js
module.exports.getUser = userId => {
const sql = {
sql: "SELECT * from user where user_id=?"
};
const sqlParams = [userId];
connection.query(sql, sqlParams, (error, results, fields) => {
// Handle error after the release.
if (error) throw error;
console.log(results);
return results;
});
};this is my service.js
module.exports.getUser = () => {
let user = User.getUser(1);
console.log(user);
return user;
};But in my service.js file its coming as undefined but in model.js (inside the callback) its printing the results correctly.
how can i pass this results back to the calling method in service.js
It should be a syntax problem but i think i'm using the correct syntax
can anyone help?
hi there, i had a problem with my sql, it's simple but i can't figure out why it can excute sometimes but offten can't excute successfully.
DELETE FROM general_log where sqltext='SET NAMES utf8' LIMIT 240the error is
[Err] 1206 - The total number of locks exceeds the lock table size
Hi everyone, check this repository if someone is looking to have web based tool to access your mysql database.. or you guys can contribute for quick releases.
https://github.com/syamdanda/mySequelWeb
https://github.com/syamdanda/mySequelWeb
Hi, Can someone help me out with this query?
CREATE TABLE
PRIMARY KEY (
KEY
KEY
) ENGINE=MyISAM DEFAULT CHARSET=latin1
I don't understand what "KEY
CREATE TABLE
nflfeedjoblog (BatchId int(30) NOT NULL AUTO_INCREMENT,processDate datetime DEFAULT NULL,status smallint(6) DEFAULT '0',pmid int(11) DEFAULT '0',NFLTransactionId int(30) DEFAULT '0',PRIMARY KEY (
BatchId),KEY
NewIndex1 (BatchId,NFLTransactionId),KEY
NewIndex2 (processDate)) ENGINE=MyISAM DEFAULT CHARSET=latin1
I don't understand what "KEY
NewIndex1 (BatchId,NFLTransactionId)" tjhis does ?
Sorry if this sounds dumb but Im fairly new to databases. Thanks in advance.
Hi guys! Having made a simple query with count() operator i'm obtaining badly formatted response where the value's name in object is a part of my query that looks stupid
[ RowDataPacket { 'count(distinct `jpp`.`job_position_id`)': 10 } ]could I somehow change it?
Thanks.
it would be great to have something like:
[10]
or
[{'result': 10}]
or
[{'': 10}]
[10]
or
[{'result': 10}]
or
[{'': 10}]
Why this sql cannot run ?
select * from project_application_records par inner join (select * from project_version pv where pv.project_id = par.project_id order by version desc limit 1) as prv