I'm trying to do is fetching the data according to timestamp from DB once (call it origin) and wait for 30sec fetch it again with same query(call it recent) in
how would i make multiple MySQL querys in NodeJS, in the following code con = mysql.createConnection(...) con.query(`SELECT * FROM BRUGERE WHERE username = ${us
I have to generate 'yearquarter' combinations within a specific date. example: start_date = '2021-01-30' end_date = '2022-05-01' Output: result = [ '2021Q1',
SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and ta
Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken un
I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE
I'm struggling to get text from an input file into MySQL with Julia. Using this code: using CSV using MySQL conn = DBInterface.connect(MySQL.Connection, "local
I have three DBs, of which hibernate can only create 2/3. Can someone explain why hibernate can not create a third table "goods" 1: org.hibernate.tool.schema.sp
I'm trying to migrate from a dump to a base in OceanDigital, and I'm having the following problem: the dump keeps loading forever without any signal that it's p
Im currently configuring a CI pipe for my laravel project via github actions. This is my build.yml file # GitHub Action for Laravel with MySQL and Redis name: A
Hi I have this three very simple tables but I can't fix it to get the right format of foreign key. CREATE TABLE company( company_name varchar(30) UNIQUE NOT NUL
I have two tables that I'm working on for a project at work. The first table (crm_users) has id, username and 16 fields that start with "state_license_" with a
I recently deleted mySQL and now when i am trying to reinstall it is giving me an error while configuring the mySQL Server i have tried deleting everything from
I've been trying to migrate a PSQL (v13.4) database to MySQL (8.0.26) with the Migration wizard tool from Mysql Workbench. I've had to change some code from "db
Suppose I have a table that looks like this: OrderNumber OrderType 1 D 1 D 1 R 2 D 2
Here is my query: SELECT DISTINCT takes.semester, takes.sec_id, takes.course_id, instructor.name, COUNT(takes.ID) FROM takes INNER JOIN teaches ON takes.cour
Totally MySQL newbie here. I'm a network systems management student and I have a problem with one of the exercises. The exercise asks to create a function that
The installation failed at this point I have already installed Microsoft Visual Studio c++ 2019. I already uninstalled and delete all the hidden folders. I rea
I am writing to-do list web app with spring boot. I Have 2 entities: User (fields: userid (ID), username, password Item (fields: serialnumber (ID), task, userid
I have 2 tables projects and images. My goal is to get all images of a project and get this kind of response. { "data": { "id": "this is project id",