Variable as column or table name

[devikacs]

Can I use a variable as the column name or table name in a stored procedure. I want to use it for update and insert statements

[sakumar9]

Can I use a variable as the column name or table name in a stored procedure. I want to use it for update and insert statements

Yes, it is possible to have table/column names as variables. In that case, you will have to use dynamic statements to execute the commands. For example:

    CREATE PROCEDURE test
    (IN tabname CHAR(6))
    LANGUAGE SQL
    BEGIN
    DECLARE stmt VARCHAR(1000);

    SET stmt = 'INSERT INTO '|| tabname || 'values (1)';
    PREPARE s1 FROM stmt;
    EXECUTE s1;
    END @

Regards
-- Sanjay

[devikacs]

Thanks a lot. ..........

Yes, it is possible to have table/column names as variables. In that case, you will have to use dynamic statements to execute the commands. For example:

    CREATE PROCEDURE test
    (IN tabname CHAR(6))
    LANGUAGE SQL
    BEGIN
    DECLARE stmt VARCHAR(1000);

    SET stmt = 'INSERT INTO '|| tabname || 'values (1)';
    PREPARE s1 FROM stmt;
    EXECUTE s1;
    END @

Regards
-- Sanjay