Recently i got mac m1 i am running a product which uses [email protected] installed through homebrew, the data from the product is connected successfully to mysql and started populating but nearing the end of population there is a connection problem…
Edited to clarify and simplify I have the following query select Signups.user_id, Count(timeoutTable.user_id) as timeoutCount, Count(confirmedTable.user_id) as confirmedCount from Signups left join ( select * from Confirmations where action = 'timeout' ) as timeoutTable on signups.user_id = timeoutTable.user_id left join…
I'm trying to build a request that returns all users that are a subset of a specific user ID (via connected_id), who are also between one or many age ranges (eg "20-30", "50-60"). The list of ages ranges are presented…
I am using MariaDB and I am trying to create a query that updates the boolean column is_popular of my photos table, called Pics. To find out which photos are "popular", I pick the top 10 from the entire table.…
I have a big table (~30M rows), it usually run fast( 5-6ms per request). Sometimes one request take a lot of time (something like 60sec). Here the table structure : CREATE TABLE table ( id int(11) NOT NULL, A int(11)…
I am trying to use a variable to hold the results of a stored function in MySQL. I get a syntax error that I cannot reconcile when I try to set the variable. The name of the function is checkAddress(v1,…
I have these three tables: hotel hotel_id hotel_name room room_id hotel_id room_price room_id start_date price Where ‘start_date’ stores the date the price changed to ‘price’. I know how to query the database to get the price for a given room_id…
I'm not sure how to word the question for the title. If there is a correct way to word this question better, I would appreciate it. I have a denormalized table, records, with columns: biz_address, customer_name, dept_ID, order_ID, order_amount. biz_address…
I have SQL view data_start with 3 columns CALMONTH, COSTCENTER, Kontonummer Sample data: CALMONTH COSTCENTER Kontonummer ------------------------------- 202301 A AA 202302 A AB 202101 B BA 202012 B BB 202204 C CA 202312 C CB ... How can I keep…
I want to run this query: UPDATE users as u INNER JOIN (SELECT MIN(updated_at) as start, h.uuid From users_history as h where h.promoted = true) new on new.uuid = u.uuid SET u.start_time = new.start; And I'll get the following error:…