Question

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, and include a column list with the required columns in the INSERT statement.

Answer 1

INSERT INTO Terms (terms_id, terms_description, terms_due_days)
VALUES (6, 'Net due 120 days', 120);