I have a problem statement: Write a Stored Procedure that populates a table with certain date attributes. The data would be populated for 1 year. For example the date 14-07-2020 is passed as an input parameter, then the stored procedure…
hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc.. I want to get all the list of the attributs(even the attributs of the parents) i wrote…
I am trying to write a stored procedure in MariaDB/MySQL that will return table names, if any, within the schema that matches a pattern provided by the parameters. Guessing this is accomplished by querying the information_schema table, but any advice…
I have the following stored procedure in MySQL that reads a JSON array of objects and insert the objects in a JSON column of a temp table: DELIMITER $$ DROP PROCEDURE IF EXISTS proc_json $$ CREATE OR REPLACE PROCEDURE myProcedure(IN…
I am calling a stored procedure within an API, creating a simple registration/login system. db.executeQueryWithParams(config.storedProcedures.CheckEmail, email, (err, result) => { if (err) { console.log(err); } else { console.log("succeeded - ", result); ; } }); This "ExecuteQueryWithParams" is a standard function…
I can easily write a stored procedure that would take inputs and use them to update a table: CREATE PROCEDURE update_table ( IN parameter1 datatype1, IN parameter2 datatype2, ..., IN parameterN datatypeN ) BEGIN UPDATE table_name SET column1 = parameter1,…
I hate asking for help (in general) but also on here because most of my issues are probably easily solvable, but I'm new-ish to programming and cannot get past this bug. I'm developing a C# application that takes user input…
I have a mysql procedure which has out parameter and some print statements for debugging. I am calling this procedure from Unix shell script, idea is to assign the out parameter to a unix variable, which i use to check…
master_table: _id zipcode 123 100 456 200 temp_table: _id zipcode 123 111 245 222 master_table (new results must be upserted in master_table) _id zipcode 123 111 456 200 my end goal is to insert records from temp_table to master_table and…
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`…