this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…
I need to add a new row for all post_ids that equal specific condition. So there is a table with post_id, meta_key and meta_value id post_id meta_key meta_value 1 100 page-type city 2 100 banner "banner" 3 101 page-type city 4 102 page-type city…
I am new to SQL. in my query, I need max closeprice(column-name) with date (column-name). every month of that year. I created this query: Select max(close), date from commodity where commodity ='rice' and location= 'pune' year(date) ='2022' group by month(date)…
/suppose that in a Table named Team contains 4 records, we need to schedule a match between each team vs opposite team:/ India Pakistan Srilanka Australia OUTPUT Australia VS India Australia VS Pakistan India VS Pakistan Australia VS Srilanka Pakistan…
I have two tables I need to join these table and there is a possibility that joined table might return duplicate rows but there is column updated date which will be unique so I need to fetch record from these…
Let's say I have two tables like below: users table: user_id name 0 kevin 1 alice 2 jake 3 mike permissions table: user_id permission 1 12 1 5 3 1 And let's say that I want to add permission 5…
I am trying to create a database use mysql workbench and I keep getting this error and my code looks fine. Not sure how I can resolve this. This is the error I am getting: Error Code: 1049. Unknown database…
I have the following SQL query: SELECT `NeighbourhoodName`, count(NAME) as `Number of Parks`, sum(CASE WHEN `parks`.`Advisories` = 'Y' THEN 1 ELSE 0 END) as Advisories, FROM parks GROUP BY `NeighbourhoodName`; In the second line of the code, I create a…
Table CREATE DEFINER=`root`@`localhost` FUNCTION `GetGPA`(sName VARCHAR(45)) RETURNS float DETERMINISTIC BEGIN DECLARE grade FLOAT; DECLARE sName VARCHAR(45); SELECT GPA INTO grade FROM student WHERE studentName = sName; RETURN grade; END I did the function and it returned null: Stored Function I…
I was looking for a workaround for configuring my database connection. I saw that opening 3306 port is dangerous and we should be using SSH Tunnel instead to connect to the database. I configured my MySQL server using docker and…