Back
Uncategorized

ITD 256 Northern Virginia Community DDL Queries Cloud Instance Database Practice

ITD 256 Northern Virginia Community DDL Queries Cloud Instance Database Practice ITD 256 Northern Virginia Community DDL Queries Cloud Instance Database Practice.

Description

DDL Queries:

1. While connected to your MySQL cloud instance, create a new database named cupcake_shop. (see https://www.w3schools.com/sql/sql_create_db.asp (Links to an external site.))

Make sure you are ‘using’ your new database by issuing the command use cupcake_shop;

 2. Create a table named order with the following fields and data types: (see https://www.w3schools.com/sql/sql_create_table.asp (Links to an external site.))

  • order_id as an integer and primary key, with auto_increment
  • order_date as datetime and not null (optional default as now())
  • cust_name as a varchar(100) and not null
  • product_name as a varchar(50) and not null
  • product_price as decimal(10,2) and not null
  • quantity as integer and not null

ITD 256 Northern Virginia Community DDL Queries Cloud Instance Database Practice

ITD 256 Northern Virginia Community DDL Queries Cloud Instance Database Practice
Facebook

We use cookies to give you the best experience. Cookie Policy

× How can I help you?