Re: Temporary Tables Aliasing in Stored Procedure

[Melvin Zamora]

Hi guys, since you have been discussing temporary table, let me insert my small problem puzzling me on MySql 5.x. Hoping that somebody also has concern to this... checking if table exists through conditional statement.

DELIMITER //
CREATE PROCEDURE MY_PROCEDURE()

...

-- A
IF TABLE MY_TEMPORARY_TABLE EXISTS THEN
-- I DO SOMETHING HERE...
END IF;

...
BEGIN
END; //

DELIMITER ;

Under that -- A comment, the conditional statement querying if MY_TEMPORARY_TABLE exists (this is only my assumption), does anybody knows the correct syntax of that? Doing query check if TABLE (temporary) does exists?

I need your help guys... I don't know if there is a syntax for this or whatever.

ps: I have already post this as subject: StoredProcedure temporary table checking.


My Gratitude,

Melvin R. Zamora