Now that you know how to create databases and tables, it’s time to turn your attention to modifying data, such as inserting, updating, and deleting it.
In this chapter, we’ll cover the following:
- Inserting data
- Updating data
- Deleting data
After creating a table, you need to be able to add data such as rows to a table. You do this by using the
INSERT statement has these parts:
INSERT INTO <table> (<column1>, <column2>, ..., <columnN>) VALUES (<value1>, <value2>, ..., <valueN>)
Using this syntax, let’s add a new row to the MySqlTable table of the newly created SQL2012Db database.
To insert a new row into a table, open a New Query ...