MySQL – Temporary Tables in Stored Procedures

MySQL Temporary Tables have the same functionality as standard disk-based tables except they exist in memory. Since memory is not long term storage, they are temporary tables, hence the name. Temporary Tables, or temp tables for short, allow you to

Read More MySQL – Temporary Tables in Stored Procedures

MySQL- Commands out of sync you can’t run this command now

Today, I coded a piece of PHP where there were 2 consecutive calls to 2 MYSQL stored procedures (select statements). The first “call” queried the database and populated a page area with the result, and the second call came right

Read More MySQL- Commands out of sync you can’t run this command now

How to – Get Return Value From Stored Procedure

Up to now I was all about problem solving. I decided to, from now on, post “how to” posts too. First one is about returning a scalar value from a stored procedure and getting that value in the code. There

Read More How to – Get Return Value From Stored Procedure