I'm executing SQL against a MySQL database and trying to write commands to delete all rows in a table. When I run "DELETE FROM MyTable" I get the error 1175 because a safety feature is turned on by default that…
I am new to SpringBoot and Postman and just started learning Java I was following a tutorial, but I keep getting the following error when I try to POST using POSTMAN after running my files on SpringBoot: I have double…
I found 85 duplicated names in my base with SELECT Name, COUNT(*) FROM Tab GROUP BY Name HAVING COUNT(*) > 1 ORDER BY 2 DESC, 1; with the result set: Name COUNT(*) a 28 b 12 c 10 d 8…
I have a dataset like this: id : E.g. 111, 111, 111, 112, 112, 113, 113 Year: E.g. 2010, 2011, 2012, 2010, 2011,2010, 2015 Sex: E.g. M, M, F, F, F, M, M In this dataset, ID = 111 had…
I am trying to query all unique city names for one particular state without pulling other states. This is what I am trying to do: SELECT DISTINCT city_name FROM table WHERE state = 'California'; This does not work because there…
I have an table and I want to fill the null value with previous value order by date but there have an group too For example: Table X: Date Group value 1/1/2023 A null 2/1/2023 A Kevin 3/1/2023 A null…
I have tables named course, student and students_in in a MySQL database. The tables look like this: course course_id name 3 Physics 12 English 19 Basket Weaving 4 Computer Science 212 Discrete Math 102 Biology 20 Chemistry 50 Robotics 7…
I have the following query: UPDATE items SET quantity = quantity - 1 WHERE quantity > 0 AND user_id = $1 AND item_id IN (5, 6, 7); I'd like to modify it such that the update will only occur if…
SQL Query like this below select json_build_array( json_build_object( 'entegrator_name', e2."name", 'provider_name', p."name", 'table1_count', count(t1.id) ) ) FROM table1 AS t1 JOIN entegrators AS e2 ON e.entegrator_id = e2.id JOIN providers AS p ON e.provider_id = p.id GROUP BY e2."name", p."name"…
I have a two-column table: product name cars ["bmw", "mazda", "ford", "dodge"] fruit ["lemon", "orange", "lime", "apple"] I'm using a wildcard to search the product's name column. My question is, is there a way to search a column only by…