Please help don't rejectFind error to inserting table I need querry MYSQL [jsohn6]> DESC COURSE;Field| Туре| Null | Key | Default | Extra || varchar(20) | NO| YES| varchar(20) | YESCOURSE_DESCRIPTION | varchar(30) | YES| varchar(10) | YESCOURSE_TYPEDEPARTMENT_IDPRI NULL| int(11)| MUL NULL| NULL| NULL| MUL NULLCOURSE_TITLE| 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 the right syntax to use near 'Fashion','Art of fashion design','F');<' at line 1

- We need to show the error in the statement written for sql table.

MYSQL [jsohn6]> DESC COURSE; Field | Туре | Null | Key | Default | Extra | | PRI | NULL MUL | NULL COURSE_TYPE DEPARTMENT_ID COURSE_TITLE COURSE_DESCRIPTION | varchar(30) | YES | COURSE_TYPE_CODE varchar(20) int(11) varchar(20) NO | YES YES NULL | NULL | MUL | NULL | varchar(10) | YES 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 fo he right syntax to use near 'Fashion','Art of fashion design','F');

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

Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.
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
Function is given:-
4
A Pivot Table is the column name with its table name. O True O False
Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133
Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.