MySQL Tutorial/Procedure Function/Drop Table

Drop a TEMPORARY table in a procedure

   <source lang="sql">

mysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myFunction()

   -> BEGIN
   ->         DECLARE i INT DEFAULT 1;
   ->
   ->         CREATE TEMPORARY TABLE ascii_chart
   ->             (ascii_code int, ascii_char CHAR(1));
   ->
   ->         WHILE (i<=128) DO
   ->                INSERT INTO ascii_chart VALUES(i,CHAR(i));
   ->                SET i=i+1;
   ->         END WHILE;
   ->
   ->         select * from ascii_chart;
   ->
   ->         drop table ascii_chart;
   ->
   -> END$$

Query OK, 0 rows affected (0.00 sec) mysql> mysql> delimiter ; mysql> mysql> call myFunction(); +------------+------------+ | ascii_code | ascii_char | +------------+------------+ | 46 | . | | 47 | / | | 48 | 0 | | 49 | 1 | | 50 | 2 | | 51 | 3 | | 52 | 4 | | 53 | 5 | | 54 | 6 | | 55 | 7 | | 56 | 8 | | 57 | 9 | | 58 | : | | 59 | ; | | 60 | < | | 61 | = | | 62 | > | | 63 | ? | | 64 | @ | | 65 | A | | 66 | B | | 67 | C | | 68 | D | | 69 | E | | 70 | F | | 71 | G | | 72 | H | | 73 | I | | 74 | J | | 75 | K | | 76 | L | | 77 | M | | 78 | N | | 79 | O | | 80 | P | | 81 | Q | | 82 | R | | 83 | S | | 84 | T | | 85 | U | | 86 | V | | 87 | W | | 88 | X | | 89 | Y | | 90 | Z | | 91 | [ | | 92 | \ | | 93 | ] | | 94 | ^ | | 95 | _ | | 96 | ` | | 97 | a | | 98 | b | | 99 | c | | 100 | d | | 101 | e | | 102 | f | | 103 | g | | 104 | h | | 105 | i | | 106 | j | | 107 | k | | 108 | l | | 109 | m | | 110 | n | | 111 | o | | 112 | p | | 113 | q | | 114 | r | | 115 | s | | 116 | t | | 117 | u | | 118 | v | | 119 | w | | 120 | x | +------------+------------+ 128 rows in set (0.02 sec) Query OK, 0 rows affected (0.28 sec) mysql> mysql> drop procedure myFunction; Query OK, 0 rows affected (0.00 sec)</source>