Drop table by procedure : Procedure « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. Procedure

Drop table by procedure

       


mysql>
mysql>
mysql>
mysql> delimiter $$
mysql>
mysql> CREATE PROCEDURE DROP_TABLE(IN TABLENAME VARCHAR(64))
    -> BEGIN
    ->    SET @SQL_STATEMENT = CONCAT('DROP TABLE ', TABLENAME);
    ->    PREPARE S1 FROM @SQL_STATEMENT;
    ->    EXECUTE S1;
    ->    DEALLOCATE PREPARE S1;
    -> END$$
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> delimiter ;
mysql>

mysql>
mysql>
mysql>

   
    
    
    
    
    
    
  

Related examples in the same category