How can I create a calculated field for this table?

SELECTbook.BookTitle,author.Name,author.Surname,book.YearofPublicationFROMbookLEFTJOINauthorONbook.AuthorID=au...

From [MySQLdiscussion group] 2023-09-07 13:52:18 0  1  576

MySQL: Guide to Opening and Transposing Lists

I have a given dataframe: list of id numbers 2[1,2,5,6,7]5[1,2,13,51,12] where one column is just the id and t...

From [MySQLdiscussion group] 2023-09-07 13:24:07 0  2  500

SQL: Calculate if an ID that has only appeared in the last week has not appeared

I'm trying to do a weekly scroll to see if a user did or didn't attend an event. However, I only want to list ...

From [MySQLdiscussion group] 2023-09-07 11:58:57 0  1  499

Can you INSERT SELECT multiple rows without running select on the same row each time?

If I have a table and need one value from another and the other values ​​come from somewhere else, do I have t...

From [MySQLdiscussion group] 2023-09-07 11:31:14 0  1  475

"Filter" huge MariaDB/Mysql tables based on different tables

Processing large datasets in my mariaDB database. I have two tables, Table A contains 57 million rows and Tabl...

From [MySQLdiscussion group] 2023-09-07 10:51:26 0  2  593

Equivalent MySQL regular expression, equivalent to the following Python regular expression

python schema =>^(?=.\bABDUL\b)(?=.\bHAI\b.)(?=.\bMANSOOR\b).*$ Need equivalent mysql schema can you help m...

From [MySQLdiscussion group] 2023-09-07 10:04:39 0  1  426

Do the flat files need to have the same json format?

You can see the different responses from the API explained: In the screenshot shared above, I compared two dif...

From [MySQLdiscussion group] 2023-09-07 09:19:43 0  1  574

Method to prevent drop-down list from duplicating items in ASP.NET VB.NET

PublicSubTable()DimConnectionAsMySqlConnectionDimDataAdapterAsMySqlDataAdapterDimCommandAsMySqlCommandConnecti...

From [MySQLdiscussion group] 2023-09-07 09:26:11 0  1  539

SQL - How to get the latest entry between two different tables? (The timestamp is not stored)

I'm working on an ongoing project in which I'm dealing with quotes and the database structure is not well orga...

From [MySQLdiscussion group] 2023-09-07 00:14:25 0  1  604

Change {oj } SQL query to normal SQL syntax

Can I ask you to help me convert this {oj}SQL syntax to normal connection syntax? SELECT...FROM{oj(((((((((&qu...

From [MySQLdiscussion group] 2023-09-07 00:20:45 0  1  652

MySQL query using group by clause returns more rows than without group by clause

Without the groupby clause, only 1 record is returned; among them, the required number of records is returned ...

From [MySQLdiscussion group] 2023-09-06 23:29:47 0  1  706

Why are only the results of the first database query displayed and the functionality of the second query ignored?

The following output shows the results of the first query, but not the second query. When I query without usin...

From [MySQLdiscussion group] 2023-09-06 22:32:01 0  1  472

How to group MySQL rows using a combination of non-null values

How to merge/combine rows by selecting the latest non-null value of each column in the grouped result? id user...

From [MySQLdiscussion group] 2023-09-06 21:35:03 0  1  607

How to solve this SQL syntax error problem?

I'm getting an error with the server regarding a request to the database. This is the error message: java.sql....

From [MySQLdiscussion group] 2023-09-06 21:08:29 0  1  464

SQL Request Guide in Laravel

I have a working request in phpMyAdmin SELECTDISTINCTid,name,articulFROMproductsWHEREcategory_id=40orderbyarti...

From [MySQLdiscussion group] 2023-09-06 19:29:24 0  1  539