Example Table: id groupId data 1 2 apple 2 5 cinnemon 3 5 bacon 4 5 pickles 5 5 wonka 6 42 bar 7 42 linux 8 69 rocks 9 69 joe 10 69 bob 11 101 briggs 12 101…
I have an app with Google Map, on each zoom change or change in map boundaries, I do a call on the backend to get points in boundaries. We have a large database, about 3 million records, so it take…
How can I create an UPDATE statement using MySQL to set a unique sequential value WITHIN clusters / groups of records? I have a table with columns for UniqueID, State ("AL", "CA", etc.), PersonName, and StateID. I need to number…
I have a PHP class that handles encryption and decryption which stopped decrypting recently after a MySQL upgrade from 5.7 to 8 and migration to a new server. I need to decrypt the data in the database that was encrypted…
I have an sql table in phpmyadmin db which has 8 columns. I want to check if 4 of them (specific 4 columns) equals to some value. For the example, lets say the value is "abcd", and the columns names…
Suppose I have clients and services of the following schema: create table client ( id INT NOT NULL, name varchar(100) NOT NULL, PRIMARY KEY ( id ) ); create table service ( id INT NOT NULL, client_id INT NOT NULL,…
There is a hospital database that has the following schema for admissions table: patient_id INT admission_date DATE discharge_date DATE diagnosis TEXT room_id INT doctor_id INT insurance_id INT here's what I am trying to query: fetch the total amount of admissions…
I have one table like below query mysql> select *from DemoTable; This will produce the following output − +--------------------+ | ListOfValues | +--------------------+ | 20, 10, 40, 50, 60 | +--------------------+ 1 row in set (0.00 sec) Expected output is…
I have a function that I query my database: void update_layout_database() char query[255]; MYSQL_ROW row; float wd,ht; sprintf(query,"SELECT name,wd,ht FROM pagelayouts WHERE drawing=%s AND handle=%ld;",drawing_number,layoutID); mysql_query(sqlconnect,query); MYSQL_RES *result = mysql_store_result(sqlconnect); row=mysql_fetch_row(result); if(row!=NULL){ if(atof(row[1])==0 || atof(row[2])==0 || !strcmp(row[0],"Model")){ wd=Extents[2]-Extents[0]; ht=Extents[3]-Extents[1]; sprintf(query,"UPDATE…
I Have one table i.e discount_details. I have 2 columns are the ID , DiscountTotal. I want to sum the each record line total json object with in the D array (64,10,10 are the 1st record values) . Like here…