Mysql – OUT parameter needs INPUT
I am doing a course on SQL on MYSQL workbench. In the course I had an exercise in which I had to take an IN parameter value and save as an OUT parameter value for further use. I came up…
Getting error "statement.executeupdate() cannot issue statements that produce result sets." when trying to insert into mysql using JDBC
I'm trying to get the primary auto incremented key from one table and store this in another using MySQL connector and JDBC. Although its giving me this error: statement.executeupdate() cannot issue statements that produce result sets. I think its something…
MySQL – Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger (select)
I am new to MySQL and learning about trigger. I have 2 tables that I want : when a table (detail_transaction) has been inserted, a 'stock' field of another table (item) change. 'item' Table id name price stock 1 Item_A…
Transfer WordPress Plugin to a new site? – Mysql
how is the procedure to transfer one plugin to site A to B with the plugin data included? I am able to transfer the FTP data for sure but I need the saved files of the plugin also. So I…
ERROR: You can't specify target table 'wpp' for update in FROM clause – Mysql
I am trying to UPDATE table value where meta key value _stock_status and id value list of ids, but i got an error (You can't specify target table 'wpp' for update in FROM clause). please advise here is my query…
Mysql – Counting number of rows between 2 dates and 1 where clause
I've a mysql table with me Now we want to do some calculations like this count date wise for all courses enrolled count where course id = 2 for date > start_date AND date < end_date Expected output where we…
How to uniquely order a MySQL table with a multi column primary key
Good day all I have a strange query. Let's say I have a table with a composite primary key (2 columns). CREATE TABLE `testtable` ( `ifk1` INT(10) NOT NULL, `ifk2` INT(10) NOT NULL, `data1` VARCHAR(10) DEFAULT NULL, PRIMARY KEY (`ifk1`,`ifk2`),…
Create separate columns after grouping by a particular column in MySQL
Currently, I have a DB table called mytable which looks like this id startTime result 100 2022-11-17 06:19:00 pass 101 2022-11-17 07:19:00 fail 102 2022-11-17 08:44:00 pass 103 2022-11-17 16:19:00 fail 104 2022-11-16 06:11:00 pass 105 2022-11-16 06:11:00 fail 106…
How does MySQL determine whether to use an index based on the number of "in"?
For example, if there is a table named paper, I execute sql with [ select paper.user_id, paper.name, paper.score from paper where user_id in (201,205,209……) ] I observed that when this statement is executed, index will only be used when the…
Retrieve all the bookings that overlap with a given booking start and end time. Mysql – Laravel
I am having a little trouble with the logic of this sql, I don't know why it's given me an error but the error is at line 4 "the start of the first AND". What I am trying to do…