Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MySQL Q.3) (20 points) Write an INSERT statement using a column list to add this row to the orders table. Pay careful attention to the
MySQL
Q.3) (20 points) Write an INSERT statement using a column list to add this row to the orders table. Pay careful attention to the comments below. order_id: /*The next automatically generated ID*/ customer_id: 6 order_date: Assume the order is taken on September 25, 2017, at 11:35:18 AM* ship_amount: 5 tax amount: 0 ship_date: /*Do not hard code the date and time; use a function that will insert the date and time at the moment when the record is added. */ ship_address_id: /* Hard-code the address_id value of the record added in Q.2 * card type: Visa card number: 1234567890123456 card_expires: 06/2020 billing_address_id: 8 my guitar_shop Tables addresses | Columns address id customer_id linel line2 city state zip_code phone disabled Indexes PRIMARY addresses_fk_customers Foreign Keys addresses_fk_customers | order-items -Columns item_id orderid - product_id item-price discountamount - quantity Indexes PRIMARY items fk orders items_fk_products Foreign Keys items.fk-orders Triggers Columns items_fk_produds orders order-id order_id customer_id order date ship-amount tax amount ship_date ship-address-id card_type card_number card-expires billing address_id ep Indexes PRIMARY ordersfkcustomers - - VE Foreign Keys orders_fk_customers ] Triggers products [05] Columns o columns product_id category_id product-code product-name description list-price discount-percent dateadded - ep Indexes PRIMARY product-code products-fk. categories VE Foreign Keys products_fk_categories Triggers Views Stored Procedures Functions Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started