How to insert data into temporary table using Procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • skysys1
    New Member
    • Feb 2012
    • 1

    #1

    How to insert data into temporary table using Procedure

    DROP TEMPORARY TABLE IF EXISTS temptable;
    CREATE TEMPORARY TABLE temptable(
    name char(30),regno int;
    )

    delete from temptable;

    INSERT INTO temptable values(calling another Procedure Here);
Working...