Chapter 5. Manipulating Data

Prices go up. People move. Companies merge. Overpasses need to be built. Life changes and the data in a database must be updated to reflect this. Additionally, sometimes design choices for tables and databases might need to be rethought, requiring changes to both the data and the structures in which the data is stored.

The phrases in this Chapter focus on the hows and whys of changing data that is already stored within MySQL tables, with a little bit of changing MySQL tables thrown in for good measure.

Safety Tips

There is no undo feature in MySQL. If you issue a query such as DROP DATABASE test, all of the tables stored in test are instantly deleted. If this query was issued by mistake, you can only recover the data ...

Get MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.