ITS410 Changing A MYSQL Table Structure

in /by

ITS410 Changing A MYSQL Table Structure

Option #1: Changing a MySQL Table Structure

Using the world_x database you installed in Module 1 and your MySQL Workbench, create a new table named “independence” with the following attributes (columns):

  • A field named “id” which has data type auto_increment,
  • A field named “country_name” which has data type varchar(50), and
  • A field named “independence_date” which has type “date.”

After you create the table, run the following SQL command:

INSERT INTO independence(country_name, independence_date) _x000D_
VALUE (‘United States’,’1776-07-04’)

Submit a 1-page Microsoft Word document that shows the following:

  • The SQL command you used to create the “independence” table and a list of the rows in the “independence” table.
  • Explain the purpose of the field named “id.” Why do you not have to include it in an insert statements? How would change the incrementing value to a number greater than one?

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper