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 517

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 515

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 501

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 414

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 408

MySQL: "Select text from... as "

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 489

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 323

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 448

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 404

The entity warehouse extends JpaRepository and JpaSpecificationExecutor, and EntitySpec extends Specification

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 394

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 365

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 350

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 486

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 350

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 435