Working with data
The single most valuable component of any computerized system is data; without it, the system is meaningless. Over time, as the system is used, the data will build up to a point where it can provide valuable insights into a business and enable forecasting based on past trends, upon which business decisions will be made.
We will now start working with data, beginning with some simple additions, updating and removing records, through to more complex reading of the data from several joined tables for reporting purposes.
Types of SQL statements
SQL statements come under several main categories when working with MySQL:
- System: The statements will interact directly with the server to perform system-related tasks.
- Database maintenance: Statements that will work with the database, such as table and foreign key creation.
- Data manipulation: Statements that work directly with data, such as Insert and Update. We will be working with these, as these...
