I have tried to show sql query result on click a button in node js Like on click a button, it show the result of sql query below that button
I have tried to show sql query result on click a button in node js Like on click a button, it show the result of sql query below that button
I have MariaDB on my server with 16/32 CPU cores, Everything seems to be ok when running mysqltuner except InnoDB Write Log efficiency, taking 1953.15%, wonderi
I'm learning about sharding approaches. How to achieve good horizontal scalability with a large number of shards in an IO-heavy application. Below I describe a
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