Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
SQL =========================== Country Table: countryId: integer not null auto increment primary key countryCode: varchar not null =================================================================================== --create the "Country" table --Insert a new row into the "Country" table with a "countryCode" of 'CA'. --Insert two new rows into the "Country" table with "countryCode" values of 'DE' and 'IT'.

SQL =========================== Country Table: countryId: integer not null auto increment primary key countryCode: varchar not null =================================================================================== --create the "Country" table --Insert a new row into the "Country" table with a "countryCode" of 'CA'. --Insert two new rows into the "Country" table with "countryCode" values of 'DE' and 'IT'.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter10: Data Analysis With Power Tools And Creating Macros
Section: Chapter Questions
Problem 6AYK
See similar textbooks
icon
Related questions
Question

SQL

===========================

Country Table:

countryId: integer not null auto increment primary key

countryCode: varchar not null

===================================================================================

--create the "Country" table


--Insert a new row into the "Country" table with a "countryCode" of 'CA'.


--Insert two new rows into the "Country" table with "countryCode" values of 'DE' and 'IT'.


--Select all rows from the "Country" table.


--Select the "countryCode" value for the row with "countryId" equal to 3.


--Update the "countryCode" value to 'UK' for the row with "countryId" equal to 1.


--Update the "countryCode" value to 'FR' for the row with "countryId" equal to 2.


--Delete the row from the "Country" table with "countryId" equal to 3.
Expert Solution
steps

Step by step

Solved in 3 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS