MYSQL [jsohn6] > DESC COURSE;Field| ТуреNull Key Default Extravarchar(20) | NOYESvarchar(20)| YESCOURSE_DESCRIPTION varchar(30) | YESvarchar(10) | YESPRI NULLMUL NULLNULLNULLMUL NULLCOURSE_TYPEDEPARTMENT_IDCOURSE_TITLE| int(11)COURSE_TYPE_CODE5 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 te right syntax to use near 'Fashion', 'Art of fashion design', 'F');k'' at line 1

Question
Asked Nov 22, 2019
4 views

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
help_outline

Image Transcriptionclose

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

fullscreen
check_circle

Expert Answer

Step 1

The syntax to insert data in the table is

INSERT INTO Table_Name (field_Name1, field_Name2, field_Name3, …. field_NameN) values (value1, value2, value3,… valueN);

 

The fields can be omitted...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Create a new file (in Dev C++) and save it as lab11_XYZ.cpp (replace XYZ with your initials). Create...

A: This C++ program contains header file swap_XYZ.h and cpp file lab11_XYZ.cppswap functions for int, c...

question_answer

Q: this is for python

A: Python program to display a diagonal tableThe variables and functions used to solve this problem inc...

question_answer

Q: Use function GetUserInfo to get a user's information. If user enters 20 and Holly, sample program ou...

A: Completing the given C++ program so, that it can follow the given rubrics:In the main function, call...

question_answer

Q: How often does garbage collection run on a DC? Group of answer choices 2 hours 6 hours 12 hours...

A: In this question a user must know about Garbage collection (GC) in the computer system:Garbage colle...

question_answer

Q: Python-Coding-WHAT COLOUR SQUARE  PART 1 - Positions on a chess board are identified by a letter and...

A: Following is the python program which takes as input from user the position of chessboard. Check usi...

question_answer

Q: in c++ Given the following, use a range-based for loop to load the array with user input (include a ...

A: The C++ program to enter and display the content of an integer array by using range-based for loop, ...

question_answer

Q: Draw a NAND logic diagram that implements the complement of the following function: (AB+A’B’)(CD’+C’...

A:  Logic diagram:

question_answer

Q: A domain controller clone is a replica of an existing DC. Group of answer choices True False

A: Domain Controller:Domain controller is a server computer on Microsoft servers.The purpose of domain ...

question_answer

Q: Simplify the following Boolean function , using three- variable maps: a) F(x,y,z) = Σ (0,2,6,7) b) F...

A: Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question...