Changing a MySQL Table Structure

[ad_1]

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):

Download the world-x database from the following MySQL website: http://dev.mysql.com/doc/index-other.html

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

Sample Solution

The post Changing a MySQL Table Structure appeared first on acestar tutors.

[ad_2]

Source link