Explain the disadvantages of creating a temporary table?
- If you have already created a temporary table with a shown name and attempting to create a second one with that name results in an error.
- Persistent connections: may accomplishn't to drop the temporary table because the connection is let open for the use of
Next script:
- when a client program automatically reconnects after a dropped connection, you'll be modifying the original table after the reconnect