MySQL Stored procedure won’t fetch the whole table

Programming in mysql: MySQL Stored procedure won’t fetch the whole table on newest questions tagged mysql – Stack Overflow

First I tried this, (MySQL/phpmyadmin)

CREATE DEFINER=`root`@`localhost` PROCEDURE `tempcheck`() NO SQL 

BEGIN
SET @query_string = 'SELECT * FROM properties';
PREPARE query_statement FROM @query_string;
EXECUTE query_statement;
DEALLOCATE PREPARE query_statement; 

END

This just fetches the first record of the table ‘properties’. The table has more than one value. When I sqlquery ‘select * from properties;’ it returns the whole table.

I even tried this simple method

BEGIN

SELECT * FROM properties';

END

Tried many stackoverflow Q&As. They all suggest that I make a temp table. Even if I do, how will it return the whole table when it doesn’t return the entire table here in the first place. CAN a mysql stored procedure actually return a whole table or NOT. if it can, then how?

source: http://stackoverflow.com/questions/10815437/mysql-stored-procedure-wont-fetch-the-whole-table
Programming in mysql: programming-in-mysql