I want to find 123 in a JSON string in MySQL. Here is my query : SELECT * FROM `reports` WHERE JSON_CONTAINS(json_data, 123, "$.respCode"); When I run this code I get this error Error Code: 3146. Invalid data type for…
This is my first question on the platform and I am beginning the SQL journey! :D I have a bit of a problem with my code and i do not know what I overlooked I have a table 'Vacations' with…
This query works when I type directly into mysql but not in C#. double deltaTime = (DateTime.Now - collectTime).TotalSeconds; string query = String.Format("UPDATE buildings LEFT JOIN server_buildings ON buildings.global_id = server_buildings.global_id AND buildings.level = server_buildings.level SET buildings.storage = buildings.storage +…
I try to create a procedure that transforms the following table from: ID Visit Date 1234567 Cake 01.01.2023 1234567 Coffee 01.01.2023 1234567 Cake 02.01.2023 2345678 Coffee 02.02.2023 2345678 Coffee 03.02.2023 to: ID Cake Coffee 1234567 Max(Date) 02.01.2023 Max(Date) 01.01.2023 2345678…
I am running an Airflow job to load data into a table. The task is : query a database -> get results in pandas data frame -> pass the result set to a worker processes -> each worker process process…
I want to store a date in this format March 13, 2014 in SQL but i couldn't find the solution on how to store a date in this format in SQL I tried storing it in this format March 13,…
I have a table with multi-year data of temperature measurement. Looking for the highest measured temperatures including the date of recording from the current year only. Tried following: SELECT timestamp, temperature AS max_temp FROM table WHERE temperature = (SELECT max(temperature)…
I migrated asp.net application (copy-paste) because no access over source code. I installed the same versions of odbc Mysql connector, Mysql server etc... After the move and changing the connectionstring, I get everything started. I log in the application (which…
I have an MYSQL 8 table in which the full name of the same person (LN FN MI) is listed two different ways (two different records). Record#1 is MCCAULEY KELLY JO and Record#2 is MC CAULEY KELLY JO. There should…
I have a very simple mysql query join for storing records of instagram profiles and their posts. profiles table = 2500 records (PK = p.id) post_files table = 800,000 records (PK = pf.id) SELECT p.id, p.instagram_id, pf.filename, p.last_updated_on, count(pf.id) as…