Question: The query should be in MySQL 1. Use a text editor such as Notepad to write the SQL code that creates a table in the

The query should be in MySQL

The query should be in MySQL 1. Use a text editor such

1. Use a text editor such as Notepad to write the SQL code that creates a table in the Last Chance College database called EMPLOYEES that stores has the structure below: Table Row Name EMP_ID EMP_FIRST_NAME EMP_LAST_NAME ADDRESS CITY STATE ZIP EMAIL ADDRESS PHONE NUMBER Data Type CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR VARCHAR 2. Use the INSERT command to add data to the EMPLOYEES table. You can make up all the data but you need to have at least five rows (records). 3. Save the file as Import.txt 4. Import the data into the Last Chance Database. 5. Check the data by using the SELECT command to display all the records in the table. You should see five different rows. 6. Submit the file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!