I have an SQL Query which takes an input from a cell and queries the database to find matches. For Example SELECT Postcode FROM Table WHERE SUBSTRING(Postcode, 1, 2) = SUBSTRING('{{CollectionPostcode.text}}', 1, 2) ORDER BY Postcode ASC; If I use…
please help me, I have a string that corresponds to a SQL query; let string = `SPMAMA.DOCUMENTO AS DOCUMENTO_MAMA, NVL(SPMAMA.CARNETSALUS,SPMAMA_N.CARNETSALUS) AS CARNETSALUS_MAMA, NVL(SPMAMA.NOMBRE1 || ' ' || SPMAMA.NOMBRE2 || ' ' || SPMAMA.APELLIDO1 || ' ' || SPMAMA.APELLIDO2, SPMAMA_N.NOMBRE1 ||…
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…
I have a database with a column having JSON data that doesn't have a clear structure. It contains multiple nested tables. This data come from different surveys. I need to use SQL dynamic to automate the process of dividing this…
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 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 as: table t1 id int room text record_date timestamp How can I delete some records in t1 table, except the newest 100 records of a room(record_date is used to save the timestamp to compare with)? With…
I have multiple csv files (1 file for each city) having following structure. An example of two out of many files: CSV File 1: City_Name Pop PopDen Lit MI 45000 280 78 MI 37000 310 89 ... ... CSV File…
I want to write this type query : SELECT CASE WHEN t1.date_closed - t1.created_date < t3.estimated_solution_time_minutes THEN 'не в SL' ELSE 'в SL' END AS result but t1.date_closed and t1.created_date are intervals like this '2023-05-02 11:30', but t3.estimated_solution_time_minutes is integer…
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…