Hi i have the next SP: CREATE DEFINER=`admin`@`%` PROCEDURE `get_products_id`(IN column_name VARCHAR(50)) BEGIN SET @column_name = column_name; SET @query = CONCAT('SELECT `p`.`id` AS `id`, `p`.`image` AS `image`, `p`.`globalClasification` AS `globalClasification`, `p`.`itemId` AS `itemId`, `p`.`code` AS `code`, `p`.`providerCode` AS `providerCode`, `p`.`description`…
I have created a stored procedure in Postgres CREATE OR REPLACE PROCEDURE reset_disabled() LANGUAGE plpgsql AS $$ DECLARE BEGIN UPDATE regional_price_info SET disabled = NULL; END; $$; I tried to call procedure from the repository class in two ways however…
I'm trying to create a simple stored procedure that reads IDs from one table and deletes records that reference these IDs from another. I have a cursor which works fine, the problem is using that cursor in WHERE clause (for…
I have a scenario: I have like 5 Boolean fields in a table, I need to set an option set value based on the number of true values of those 5 Boolean Fields: Field1 Field2 Field3 Field4 Field5 ENUMField1 values…
I'm trying to make a stored procedure, using phpMyAdmin, that has 2 columns as parameters. This is the SQL code that I have to transform into a stored procedure with parameters: SELECT c1.tara, c2.tara FROM clase c1 JOIN clase c2…
I am using pgAdmin 4 to create and update stored procedures. I want to add more arguments to one existing procedure but the add option is not available: What I expect to see is the "+" option, as it appears…
I'm painfully new to SQL/mySQL as a whole so I'm flying blind right now so apologies. I made a procedure in mySQL that selects a varchar data from a specific column and table, turn it into INT (contents of said…
I have a requirement to insert new records and delete this record 3 months after created date. I will create a new table. I want that query will create the table as well as auto delete the records which are…
I want to create a procedure that receives two ids, makes two selects in a table and returns the data, after that I want to perform an update in another table using the result that was returned to me earlier,…
I am new to postgresql and am trying to update a table based on conditions using PostgreSQL stored procedure. The table 'pref2' looks like this: geneid pred_perf_r2 pred_perf_pval vers ENSG00000107959 0.03 0.02 1.0 ENSG00000106321 0.05 0.01 1.0 ENSG00000102222 0.22 0.05…