A field named “id” which has data type auto_increment,
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) VALUE (‘United States’,’1776-07-04’)
- Assignment status: Get solution from our writing team
FREE FROM PLAGIARISM
Comments
Post a Comment