How to populate array outside function clause in nodejs

I want to populate an array outside the function block app.get('/getpackages/:dateStart/:dateEnd/:limit',funct...

From [MySQLdiscussion group] 2024-02-21 18:49:57 0  1  509

Get the start date and end date of the creation time

Need help, I need to get start_date and end_date from creation_time based on is_active status. I tried several...

From [MySQLdiscussion group] 2024-02-21 18:25:26 0  1  502

How to get NULL from `SELECT IF(NULL, 2, 3)` MySQL method

I am using mysql function if. When I run SELECTIF(NULL,2,3) I get 3. When the first parameter is NULL, by chan...

From [MySQLdiscussion group] 2024-02-21 17:20:59 0  1  431

How to copy a row in the same table in MySQL only if the row does not exist?

I'm trying to figure out how to copy a row record from the same table (only if the row doesn't exist), but the...

From [MySQLdiscussion group] 2024-02-21 17:19:58 0  1  501

Troubleshoot Node.js and MySQL connection errors on Windows

First, I work in Window. I provided the necessary information accurately (host, user, password, port, database...

From [MySQLdiscussion group] 2024-02-21 16:47:21 0  1  402

If a row is deleted, trigger inserting it into another table

I'm trying to create a trigger that copies a deleted row to another table. So far when I delete a row I just c...

From [MySQLdiscussion group] 2024-02-21 15:22:36 0  1  414

Disable local connection query for Hibernate NonUniqueDiscoveredSqlAliasException

I want to join some tables using native queries in SpringBoot. The query looks like this: SELECT*FROMemployeeA...

From [MySQLdiscussion group] 2024-02-21 13:50:47 0  1  550

Mysql DISTINCT still returns duplicate values

How to avoid duplication on friends, I still get two bobs instead of only one bob My table setup: CREATETABLEu...

From [MySQLdiscussion group] 2024-02-21 13:25:49 0  2  421

Is there a way to display only the first non-zero value, but if all values ​​are zero, display the first instance of a column in a separate table from the joined table

The two tables are quite large and my select statement has more values ​​than I get, but I think I can simplif...

From [MySQLdiscussion group] 2024-02-21 12:58:34 0  2  415

Uninstall PhpMyAdmin 4.9.7 from Wampserver v.3.2.6

I downloaded the latest version of Wampserverv.3.2.6, which by default has phpMyAdminv.4.9.7 and phpMyAdminv.5...

From [MySQLdiscussion group] 2024-02-21 10:24:52 0  1  488

Calculation in MySQL's join query

I have some calculations and want to perform this in a query. There are parent and child tables with a one-to-...

From [MySQLdiscussion group] 2024-02-17 22:58:39 0  2  586

Best way to create database from external source

I'm creating an API, assuming my database has authors and books tables. The authors and books come from an ext...

From [MySQLdiscussion group] 2024-02-17 22:14:03 0  1  446

How to display the table value corresponding to its matching id

So, in the query below, I join two tables by order_id and display all values ​​from user_orders table. Based o...

From [MySQLdiscussion group] 2024-02-17 22:00:09 0  1  464

Laravel combine multidimensional array based on year value

This is the array I want to combine based on the year value 0=>array:3[▼"year"=>2022"tota...

From [MySQLdiscussion group] 2024-02-17 21:06:08 0  1  412

Reducing ID duplication: How to minimize it?

I have two tables and a linked table between them, one of users and one of holidays and a linked table of like...

From [MySQLdiscussion group] 2024-02-17 21:19:18 0  1  431