Question: The query should be in MySQL 1. Use a text editor such as Notepad to write the SQL code that will insert data into the
The query should be in MySQL

1. Use a text editor such as Notepad to write the SQL code that will insert data into the STUDENTS table. You can make up the data you insert but you need to have five different rows (students) and data for each column. You may want to look at the table structure if you are unable to remember what data you are inserting. 2. Save the file as LCCInsert2.txt 3. Import the data into the LCC database. 4. Check the data by using the SELECT command to display all the records in the table. You should see five different rows. 5. Submit the file Table Structure Table Row Name STU_ID STU_FIRST_NAME STU_LAST_NAME ADDRESS CITY STATE ZIP MAJOR EMAIL ADDRESS PHONE NUMBER Data Type CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR VARCHAR
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
