O'Reilly logo

Learning MySQL by Hugh E. Williams, Saied M.M. Tahaghoghi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 EXPLAIN statement and then improve their performance with simple optimization techniques

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required