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® Phrasebook 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.
