14 Tips and Tricks
In this chapter, you’ll build confidence in your new MySQL skills by reviewing common pitfalls and how to avoid them. Then, you’ll look at transactions and the MySQL command line client. You’ll also learn how to load data to and from files.
Common Mistakes
MySQL can process sets of information very quickly. You can update thousands of rows in the blink of an eye. While this gives you a lot of power, it also means there is greater potential for mistakes, like running SQL against the wrong database or server or running partial SQL statements.
Working in the Wrong Database
When working with relational databases like MySQL, ...
Get MySQL Crash Course 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.
