How to display only the lowest value from a result set (MYSQL)

I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'frommessagewherefaci...

From [MySQLdiscussion group] 2024-04-06 21:44:19 0  1  798

Regular expression to match words

I have a script where I am trying to match new job names with existing job names in a database. SELECTa.titleA...

From [MySQLdiscussion group] 2024-04-06 21:24:04 0  1  912

The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values

EDIT: The formula should be the "value" column - the "value" column with the lowest user_i...

From [MySQLdiscussion group] 2024-04-06 21:23:40 0  2  849

SQL Count() also requires 0

I have only one table and I want to count each entry of a tag that starts with 0. Now I try this: SELECT tag,C...

From [MySQLdiscussion group] 2024-04-06 19:48:53 0  1  708

Calculate the sum of fields in another table using MySQL SQL query

I have a schema like this: User table with attributes "user_id" and "username" and orders ...

From [MySQLdiscussion group] 2024-04-06 19:39:29 0  1  746

MySQL: "Select text from... as <variable here or subquery>"

I have the following table with the following data: id text language 1 german text german 2 english text engli...

From [MySQLdiscussion group] 2024-04-06 19:25:54 0  2  937

How to group and count in MySQL?

I'm trying to write a query that extracts the total number of undeleted messages sent to friends. Here is a sc...

From [MySQLdiscussion group] 2024-04-06 18:30:17 0  1  574

MySQL gets data from multiple tables

I have a eg_design table which contains the following columns: and eg_domains table which contains the followi...

From [MySQLdiscussion group] 2024-04-06 18:42:44 0  2  642

How to get the first name from customer_name column

selectsubstring(custommer_name,1,instr(custmer_name,''))asfirst_namefromsales.customers; this solution gave me...

From [MySQLdiscussion group] 2024-04-06 17:43:30 0  2  619

The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity>

This is my endpoint http://localhost:8080/country/all replies are ok for all countries and when I want to filt...

From [MySQLdiscussion group] 2024-04-06 17:11:03 0  1  889

Record query under partial value conditions - SQL skill sharing

I have a table called zipcode which has a column called code. The Code column contains the prefix of the zip c...

From [MySQLdiscussion group] 2024-04-06 16:01:26 0  1  597

Get the value of MySQL

Since yesterday I'm trying to get this value (see picture), I've tried using "mysqlreader, executescalar,...

From [MySQLdiscussion group] 2024-04-06 14:45:26 0  1  513

MySqlConnector: MySqlBulkLoader class. Upload empty data from csv to MySQL table

From MySqlConnector.MySQLBulkLoader class I want to convert csv to MySQL table keeping null values.

From [MySQLdiscussion group] 2024-04-06 14:35:18 0  1  678

Node.js: Unable to store SQL query results in an array

I'm trying to push the results of a SQL query to an array. However, it doesn't seem to work. I can't find a so...

From [MySQLdiscussion group] 2024-04-06 14:14:46 0  1  549

Mysql returns some records as empty in date field because date has multiple formats

I am trying to analyze order_date column and the column has multiple date formats and I want to convert all th...

From [MySQLdiscussion group] 2024-04-06 13:29:40 0  1  594