MySQL: Display daily count of rows created using inner join?

I have a user and user_data table. I'm trying to display registrations by created_at and group them by today's...

From [MySQLdiscussion group] 2023-09-11 00:12:00 0  1  895

Method to count duplicate names in Varchar/Text column in MySQL/Any SQL

So, here's the situation: I have a CSV file that looks like this: show_idtitlecast1BatmanRobertPattinson,Colli...

From [MySQLdiscussion group] 2023-09-10 23:59:22 0  1  573

I think this is a Python MySQL bug but I can't understand the situation. Internal error: Unread results found

这是我的FlaskAPI代码fromflaskimportrequestfromflask_restfulimportResourcefrommysql.connectorimportErrorfromflask_jwt...

From [MySQLdiscussion group] 2023-09-10 22:20:52 0  1  401

MySQL: unexplained date field dependency

I'm trying to update the default values ​​of two date fields in an existing database. The output of SHOWCREATE...

From [MySQLdiscussion group] 2023-09-10 22:29:38 0  1  586

Move a varchar column containing CSV format to another table

The database I created 15 years ago was poorly designed. I have a varchar column containing comma separated st...

From [MySQLdiscussion group] 2023-09-10 19:59:25 0  1  519

MySQL SELECT with GROUP BY one field and ORDER BY another field

Edit 3 - MySQL version is 8.0.33. EDIT 2 - See the final working code at the bottom. Thanks @Akina! I have a s...

From [MySQLdiscussion group] 2023-09-10 17:25:20 0  1  567

How can I adjust the timeout for a MySQL query run by PowerShell to allow more than 30 seconds to run?

I have a MySQLSELECT query that takes a few minutes when run in SQLyog (the GUI I use). When I try to run the ...

From [MySQLdiscussion group] 2023-09-10 13:18:46 0  1  679

Get records that do not exist in the connected table

I have three tables in a MySQL database. The first table contains users and the second table contains items. B...

From [MySQLdiscussion group] 2023-09-10 12:16:29 0  1  509

Extract data from first table, using data from second table

First of all, I can't find a suitable name for the question, if someone can find a better name I would really ...

From [MySQLdiscussion group] 2023-09-10 12:00:30 0  1  469

Extract data from another table in MYSQL database, making changes to existing columns

I have a MYSQL database (in PHPMyAdmin) with two tables users and posts. Both tables have a username column. I...

From [MySQLdiscussion group] 2023-09-10 08:45:15 0  1  635

MySQL WHERE clause usage

MySQL I'm trying to get Category_id values ​​between 9 and the largest category id without using the Max funct...

From [MySQLdiscussion group] 2023-09-09 20:28:44 0  1  569

Insert time format

I need help on the best data type and format needed to insert times into a table. For example, I have a table ...

From [MySQLdiscussion group] 2023-09-09 18:44:15 0  1  639

Is it wise to create different tables for the same data for each date?

I have a MYSQLInnoDB table with the following columns (table and column names changed): date (PK, date) var_a ...

From [MySQLdiscussion group] 2023-09-09 17:40:44 0  2  525

Retrieve rows in a SQL database that are fully compatible with each other

I have this simple structure in my database CREATETABLEspecies(_idINTEGERPRIMARYKEY,nameTEXTNOTNULL); CREATETA...

From [MySQLdiscussion group] 2023-09-09 17:16:24 0  2  469

Aggregate sql tables in queries in different ways

I have three tables in sql order_table(order_id,product_id,amount)products_table(product_id,name,price_usd),al...

From [MySQLdiscussion group] 2023-09-09 13:54:44 0  1  452