Chapter 8. Doing More with MySQL
MySQL is feature-rich. Over the past three chapters, you’ve seen the wide variety of techniques that can be used to query, modify, and manage data. However, there’s still much more that MySQL can do, and some of those additional features are the subject of this chapter.
In this chapter, you’ll learn how to:
Insert data into a database from other sources, including with queries and from text files
Perform updates and deletes using multiple tables in a single statement
Replace data
Use MySQL functions in queries to meet more complex information needs
Analyze queries using the
EXPLAINstatement and then improve their performance with simple optimization techniques
Get Learning MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
