MYSQL [jsohn6] > DESC COURSE; Field | Туре Null Key Default Extra varchar(20) | NO YES varchar(20)| YES COURSE_DESCRIPTION varchar(30) | YES varchar(10) | YES PRI NULL MUL NULL NULL NULL MUL NULL COURSE_TYPE DEPARTMENT_ID COURSE_TITLE | int(11) COURSE_TYPE_CODE 5 rows in set (0.06 sec) MYSQL [jsohn6]> INSERT INTO COURSE VALUES ( ' Undergraduate','101,'Fashion','Art of fashion design','F'); -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t e right syntax to use near 'Fashion', 'Art of fashion design', 'F'); k'' at line 1

MYSQL [jsohn6] > DESC COURSE; Field | Туре Null Key Default Extra varchar(20) | NO YES varchar(20)| YES COURSE_DESCRIPTION varchar(30) | YES varchar(10) | YES PRI NULL MUL NULL NULL NULL MUL NULL COURSE_TYPE DEPARTMENT_ID COURSE_TITLE | int(11) COURSE_TYPE_CODE 5 rows in set (0.06 sec) MYSQL [jsohn6]> INSERT INTO COURSE VALUES ( ' Undergraduate','101,'Fashion','Art of fashion design','F'); -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t e right syntax to use near 'Fashion', 'Art of fashion design', 'F'); k'' at line 1

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Need Correct and unique answer. Do not copy
Question: Please match the appropriate data.
Please insert the data into the database tables
_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. DIFFERENCE SELECT UNION INTERSECT
Answer question 9 only. I included the table
MySql - Procedure activity Write a procedure to add a record in the staff table with the parameters lname, fname, dob, rating and salary. Procedure should calculate the commission and gross salary. Use sequence to automatically define the next staff Id. Now insert the data into the table. Display message as “ Record created”
Attached Question:
Please share correct answer and explanation only.
The INSERT statement needs to specify column names unless _____. -multiple rows are being inserted into the table with a single statement -only one row is being inserted into the table -the values are inserted in the same order as the table's columns -the values that are being inserted are for columns that are primary keys
Please include explanation for your answer.
2-18 Please answer question. my answers are incorrect, thank you!
Table no. 1 only