Head First SQL, 2nd Edition

Chapter 11. Temporary Tables: Short-term Storage

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 11th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

Not everything needs to be permanent. So far, you’ve stored your tables of data on your computer’s hard drive, which means you’ve had unlimited access to them, even after signing out of SQL or turning off your machine. But not all tables need to be written in permanent ink. Sometimes you’ll dabble with a table for a little while, but like a bad tattoo, you hope it will just disappear on its own. Temporary tables do exactly that. Temporary tables act just like regular ones, except that they automatically delete themselves when you log out of your SQL session. If you’re worried about your intermediate tables taking up too much disk space, avoid that instant regret and give temporary tables a try.

Hot and bothered

Here is Abby’s first query. Her subquery gets the ID number for ...