Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions