How to call the procedure in Mysql...?
This is a discussion on How to call the procedure in Mysql...? within the Database Support forums, part of the Web Development category; hi... How to call the procedure within another procedure in Mysql? Regards, S.Ashokkumar...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
05-08-2007, 08:19 AM
| |||
| |||
 How to call the procedure in Mysql...? hi... How to call the procedure within another procedure in Mysql? Regards, S.Ashokkumar     |
| Sponsored Links |
|
05-16-2007, 01:37 AM
| |||
| |||
| Re: How to call the procedure in Mysql...? hi ashok, is there any tedious things? i think this will work fine CREATE DEFINER=`root`@`%` PROCEDURE `sp_test2` BEGIN CALL sp_test1(); END;
__________________ With, J. Jeyaseelan Everything Possible |
|
07-05-2007, 11:47 AM
| |||
| |||
| Re: How to call the procedure in Mysql...? Hi jeyaseelan, Yes offcourse its not a tedious one for calling Stored Procedure or a Stored Function, its a simple one as u said. But a small doubt. what does it mean by DEFINER=`root`@`%' in the given code.
__________________ -Murali.. |
|
07-06-2007, 02:34 AM
| |||
| |||
| Re: How to call the procedure in Mysql...? Hi, DEFINER=`root`@`%` - to define the username(root) of the server i think it is not necessary. without of this it can works
__________________ With, J. Jeyaseelan Everything Possible |
|
07-11-2007, 12:12 AM
| |||
| |||
| Re: How to call the procedure in Mysql...? I could not able to compile my procedure code using DEFINER=`root`@`%` ? Iam using Toad for Mysql editor for connecting mysql Database.
__________________ -Murali.. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| difference between call by value and call by reference | amansundar | Java Programming | 2 | 09-18-2007 01:34 AM |
| Can a stored procedure call itself or recursive stored procedure? How many level SP n | H2o | Database Support | 1 | 08-03-2007 10:55 AM |
| Function call and System call | vigneshgets | Operating Systems | 1 | 08-01-2007 06:18 AM |
| How Do I Call Java from C? | kingmaker | C and C++ Programming | 1 | 07-30-2007 07:58 AM |
| How to call stored procedure using HTTP SOAP? | oxygen | XML and SOAP | 1 | 07-26-2007 04:28 AM |
All times are GMT -7. The time now is 09:07 PM.
