phpCrud - generating stored procedures in MySQL

http://www.it-iss.com - phpCrud is a great tool that auto generates a number of stored procedures based on existing tables in MySQL. Visit us at http://www.it-iss.com products to download the script.

Category:

Science & Technology

Tags:

• mysql
• stored procedures
• php
• crud
• auto generate
• writing
• primary key

[webseos]

Hi, I shall be grateful if you email me at webseos@gmail.com on the following query. Say find out sum of salary of employees of employee_table where employee salary > 10000 USD not by single SUM(salary) statement but using row by row using stored procedure.

Thanks

webseos.com

[webseos]

Hi ,

I am new to MySQL Stored Procedures. But have some basic idea. So I request you to create a video for normal level users so that we can understand that.

E.g : For this query : select * from employee_table where salary > 10000;

How can we access record by record in Stored Procedures. By normal SQL we get a set of records. But if we check record by record the Stored Procedure is helpful.

I do these by PHP. as $row = mysql_fetch_array($result);

But how in Stored Procedure we can do this?