Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started