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