To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab. 1. Write an INSERT statement that adds this row to the Terms table: terms_id: 6 terms_description: Net due 120 days terms_due_days: 120 Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement. 2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due 125 days", and it should change the terms_due_days column to 125. 3. Write a DELETE statement that deletes the row you added to the Terms table in exercise 1
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab.
1. Write an INSERT statement that adds this row to the Terms table:
terms_id: 6
terms_description: Net due 120 days
terms_due_days: 120
Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement.
2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due 125 days", and it should change the terms_due_days column to 125.
3. Write a DELETE statement that deletes the row you added to the Terms table in exercise 1.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
