Author Topic: tanya mysql stored procedure  (Read 1132 times)

0 Members and 1 Guest are viewing this topic.

Offline gonzooe

  • Newbie
  • *
  • Posts: 1
tanya mysql stored procedure
« on: January 14, 2010, 11:11:22 AM »
haloo...salam kenal, saya punya problem nich, gimana caranya ya select statement di stored procedure dynamic parameter, saya udah coba seperti ini :

CREATE PROCEDURE `playground`.`passing_table`(_name_table varchar(20))
SQL SECURITY INVOKER
    BEGIN
           set @test = concat(_name_table);
           select * from @test; 
    END$$

DELIMITER ;

tapi tetep ngga bisa, ada yg bisa bantu ngga??...thx