
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Why am I getting a error message when trying to INSERT data for the table?? (photo attached)
![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](https://content.bartleby.com/qna-images/question/80c38652-684c-45be-b5e1-703e12f48783/34a444fa-a96b-4276-81e7-af66b46a3bcf/g073y1m.png)
Transcribed Image Text: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
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Step 1
VIEW Trending nowThis is a popular solution!
Step by stepSolved in 1 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Please Type! what is an Isolation property of transactions in SQL (database)arrow_forwardHow can we check if a table has minimum redundency?A) There is no way to checkB) See if a table has any primary values duplicated somewhere elseC) Use a normal form to checkD) See if a table has a lot of null valuesarrow_forwardQ2: Discuss when you should use tables and when using graphs.arrow_forward
- Explain the SQL function categories in databasearrow_forward1.Searching Algorithm Exercises Show the list of comparisons made applying the given searching algorithm to the following set of array values. Return the index of the location if the search item is found and -1 otherwise. SEQUENTIAL SEARCH BINARY SEARCH Al Fay Lee Nia Roy Tia Wes Al Fay Lee Nia Roy Tia Wes A. Find "Wes" C. Find "Wes" List of Comparisons: List of Comparisons: Returned Index Value: Returned Index Value: B. Find "Troy" D. Find "Troy" List of Comparisons: List of Comparisons: When finished, make sure to click Submit. Optionally, click Save as Draft to save changes and continue working later, or click Cancel to quit uwithout saving changes. Cancel SAMSUNG Ce %23 %24 3 4. 7 8 み マarrow_forwardThe command would be used to delete the table row where the CCODE is ' M-1:arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education