Mysql get date and date range for specific date (syntax error)

This is my complete code, but when I start it, DECLARE@StartDateTimeDATETIMEDECLARE@EndDateTimeDATETIMESET@Sta...

From [MySQLdiscussion group] 2024-02-25 19:51:13 0  1  344

Create a trigger in a mysql stored procedure

I want to create a trigger in the process. But after some research I found this is not possible. Can you sugge...

From [MySQLdiscussion group] 2024-02-25 19:35:21 0  1  474

Set the default value for MySQL connection interval year and month

There is a problem with my query. I have two tables and I want to join them to get results based on the primar...

From [MySQLdiscussion group] 2024-02-25 18:16:02 0  1  345

How to convert and save dynamic rows into dynamic columns

I have a table called events where I save every event that occurs on the website. Fiddle and code I tried +===...

From [MySQLdiscussion group] 2024-02-25 18:12:16 0  1  325

There is an ambiguous where clause for column 'status'

cursor.execute("SELECT*FROM`xplt_cases`LEFTJOIN`dgn_cases`ONdgn_cases.rid=xplt_cases.ridWHERE`status`=%(c...

From [MySQLdiscussion group] 2024-02-25 17:41:22 0  2  452

Sequelize: How to delete user related articles?

I have an article model where each article is related to a user: constArticles=db.define("Articles",...

From [MySQLdiscussion group] 2024-02-25 17:24:16 0  1  462

In SQL templates, Airflow's XCom returns values ​​as double quoted strings while Snowflake uses single quoted strings in SQL queries

I'm new to ETL and working on airflow and snowflakes. I use a python operator to get the maximum created value...

From [MySQLdiscussion group] 2024-02-25 15:36:12 0  1  479

Error while trying to build a controller in ASP.NET Core 6 Web API - Visual Studio 2022

I have created a new ASP.NETCore6WebAPI project and I am using an existing MYSQL database. I successfully set ...

From [MySQLdiscussion group] 2024-02-25 14:41:18 0  1  391

File not found

Why can't I find the network-scripts file?

From [MySQLdiscussion group] 2024-02-23 10:54:42 0  0  318

MYSQL SEARCH WHERE VALUE matches comma separated string

I have a field PROPERTY_TYPE in my table Property_types which contains a single value such as Residential, Bus...

From [MySQLdiscussion group] 2024-02-21 21:27:02 0  1  386

Explode array based on value

I have array constructed like this array(size=2)0=>array(size=12)'id_objects'=>string'2876'(length=4)'ro...

From [MySQLdiscussion group] 2024-02-21 20:42:42 0  1  308

Order clause in query takes too much MySQL load time

I'm stuck in a situation where I have millions of records and need different connections for the same records....

From [MySQLdiscussion group] 2024-02-21 20:36:00 0  1  408

SQL method to return data from multiple tables based on column names

I'm trying to do something a little weird but can't figure out the right way to accomplish it. Essentially, I'...

From [MySQLdiscussion group] 2024-02-21 19:21:21 0  1  482

Insert only enabled textbox into MySQL in VB.Net

I'm creating an inventory management system in VB.Net whose basic functionality is to process incoming invoice...

From [MySQLdiscussion group] 2024-02-21 19:42:03 0  1  436

Manually inserting into a MySQLx collection

I have a large amount of JSON data that I need to insert into a MySQLxCollection table. The current Node imple...

From [MySQLdiscussion group] 2024-02-21 19:01:38 0  1  402