stored-procedures

I need to create a MYSQL stored procedure which will use a UNION query to find an email address in one of five tables. Once the email address is…

I am trying to make a call to a stored procedure from with in a transaction in its simplified form: my $dbh= DBI->connect(............ ); my $sth…

I need to perform the same procedure for several tables in my DB. The poblem is that that procedure contains the following line: DECLARE tableIt…

Have not worked with ASP in a very long time and have never dealt with stored procedures. I am sure this is grade 1 stuff. Help will be appreciated.…

I have a stored procedure named create_new_db(p VARCHAR(45)) on mysqldb. The syntax is as follows. DELIMITER $$ CREATE DEFINER=`root`@`localhost`…

This is probably a longshot but.. is it possible to duplicate a whole database layout (tables, view, procedures, everything) with a query or…

I am trying to run a set of sql files with stored procedures and triggers in my windows XAMPP environment. Some suggested to me using a batch script…

I'm trying to an issue related to following function: CREATE FUNCTION sp_insert_new_user() RETURNS void AS $$ INSERT INTO tbl_user(id, email) VALUES…

Hi I have a simple MYSQL stored procedure which has an IN (int) and an OUT (int) parameters. I am calling the stored procedure from a PHP script.…

mysql standard query SELECT ag.`attendance_type`, ag.`description`, COUNT(a.`attendance`) attendance_count FROM `ems_attendance` a RIGHT JOIN…

1st query (select a.cat_id,a.cat_name,a.cat_description,b.subcat_name,b.subcat_description from trade_categories a left outer join…

We are at the begining of a new project, and we are really wondering if we should use stored procedures in MySQL or not. We would use the stored…

What is the regular expression pattern that enables every input besides characters? So far this is what i have - CREATE PROCEDURE Paging_Movies…

Mysql Version 14.14 Distrib 5.1.41 I have a stored procedure that I am trying to get compiled but an error keeps cropping up. My stored procedure…

I'm stuck on how to get incremented id and max, min, sum or count from the previous insertion statement. Can anyone advice me how to do that in…

I have about 2 years of mySQL under my belt but am diving into stored procedures for the first time to create an internal analytic tool for my site.…

I have mysql procedure called from coldfusion page as below. for some reason procedure executes with cfquery but not using stored procedure. any…

Will there any conflict while creating temporary tables of Same name in MySql from different Procedures simultaneously? For Ex :- I'm creating a…

I'm trying to do a procedure capable of convert broken utf8 caracters this is my SP: CREATE DEFINER=`root`@`localhost` PROCEDURE `conversorUTF8`()…

I am trying to call mysql prepare statement and stuck in php error. " Fatal error: Call to a member function prepare() on a non-object in…