Proper use of the COUNT function in MySQL

I have 2 tables, this is my fiddle http://sqlfiddle.com/#!9/da5e4e/3 so basically I have 2 tables called perso...

From [MySQLdiscussion group] 2024-04-04 13:50:47 0  1  379

How to query multiple select elements stored in database

Querying areas of expertise (stored as an array of any selected items) does not work. I'm trying to figure out...

From [MySQLdiscussion group] 2024-04-04 13:18:46 0  1  428

Is it possible to combine subqueries and joins in a single MYSQL statement?

This question confuses me. I'm trying to use Join and subqueries in mysql but I keep getting syntax errors. Th...

From [MySQLdiscussion group] 2024-04-04 13:00:10 0  1  437

Add highest value as a column using window function

I have a table like this: Query to copy data: DROPTABLEIFEXISTSunits_table;CREATETEMPTABLEunits_table(Brandvar...

From [MySQLdiscussion group] 2024-04-04 12:18:16 0  2  535

Mysql date sorting error

SELECTco.id,IFNULL(oe.follow_status,'unFollow')ASfollowStatus,co.due_timeFROMcar_ordercoLEFTJOINorder_expireoe...

From [MySQLdiscussion group] 2024-04-04 12:09:24 0  2  405

How to merge two fields with the same name but different IDs into the same row in MySQL?

I have a project where the customer can select a price based on a checkbox and the input box has the same name...

From [MySQLdiscussion group] 2024-04-04 12:13:47 0  1  396

Efficient way to fill missing values ​​in unordered map from SQL table (SQL/C++)

Question Currently there is a system that reads unique identifiers (ids) and their attached dataset from a SQL...

From [MySQLdiscussion group] 2024-04-04 11:47:44 0  1  473

Can I use json array field with IN clause

I have this query running: select*fromhousedatawhereJSON_EXTRACT(properties->"$.Type",'$[0]')in('...

From [MySQLdiscussion group] 2024-04-04 10:51:09 0  1  336

When getting data from multiple tables, how to query based on entries in the table in SQL grouping

I have two tables click 2.ride click table id | time ride table id | timestamp I want to get data from both ta...

From [MySQLdiscussion group] 2024-04-04 08:58:17 0  1  435

SQL query not showing up in specific route in Node.js

I'm new to javascript and nodejs and I have a question I have a code where I'm working on a simple API but I'm...

From [MySQLdiscussion group] 2024-04-04 00:24:22 0  1  474

MySQL procedure skips latest records

I have the following three tables; hm_deliverylog+---------------------+-------------------------------- -----...

From [MySQLdiscussion group] 2024-04-04 00:07:19 0  1  464

Unable to access sent messages using JavaScript in Postman

Using the code below, I can enter information into my MySQL table in the post method and the information is lo...

From [MySQLdiscussion group] 2024-04-03 22:02:38 0  1  425

How to conditionally get price*quantity using CASE

If I have sale_price, I will use sale_price*quantity to express the total price. If you don't have sale_price,...

From [MySQLdiscussion group] 2024-04-03 20:45:07 0  1  537

Use UNION in SQL to pivot data on two query results

I'm trying to get a pivot table of two query results from a MySql database Here is my SQL query: SELECT*FROM(S...

From [MySQLdiscussion group] 2024-04-03 19:32:52 0  2  494

Check if two values ​​in query are the same, making query very slow

My goal: Query, provide all provinces where buildings are being constructed. My problem: Once I make sure ever...

From [MySQLdiscussion group] 2024-04-03 19:06:32 0  1  419