I keep getting this error
"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 '' at line 4"
line 4 is the "Genre char(20) not null," any help or guidance would be lovely
create table Games
(gameid int not null auto_increment
primary key,
title varchar(100) not null,
Genre char(20) not null,
year_released int not null);
insert into Games(title, Genre, year_released)
values("First Fantasy XV","Role Playing Game", 2016);
insert into Games(title, Genre, year_released)
values('Horizon Zero','Role Playing Game', 2017);
insert into Games(title, Genre, year_released)
values('Ninja Gaiden Sigma','Action', 2014);
insert into Games(title, Genre, year_released)
values('Silent Hill','Horror', 2012);
create table Game_Info
(gameid int,
peopleid int,
Genre varchar(100);
insert into Game_Info
(`gameid`, `peopleid`, `Genre`)
Values
(11, 1, 'RPG'),
(22, 2, 'Action'),
(33, 3, 'RPG'),
(44, 4, 'Horror');
create table Game_Developers
(peopleid int,
first_name
varchar(30) null,
last_name varchar(30) not
null,
Age int not
null,);
insert into Game_Developers (peopleid, first_name, last_name,
Age)
values
(1,'Sam','Park',25),
(2,'Tim','Taylor',28),
(3,'Tom','Wiseman',35),
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
I keep getting this error "You have an error in your SQL syntax; check the manual...
Assume the following employees.sql file: create table employees ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT NOT NULL, first_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(50), age INT, gender VARCHAR(50), company VARCHAR(50) ); insert into employees (id, first_name, last_name, email, age, gender, company) values (1, 'Nicolas', 'Skeates', 'nskeates0@zdnet.com', 50, 'Male', 'Kwinu'); insert into employees (id, first_name, last_name, email, age, gender, company) values (2, 'Valentijn', 'Digwood', 'vdigwood1@washingtonpost.com', 40, 'Male', 'Yabox'); insert into employees (id, first_name, last_name,...
Using the code below in Oracle SQL Live I keep getting an error message for the last 4 INSERTS. The error message is: ORA-00932: inconsistent datatypes: expected DATE got NUMBER. How do I correct that error? CREATE TABLE BASE ( BASENUM CHARACTER(3) NOT NULL, BASECITY varchar(20), BASESTATE CHARACTER(2), BASEPHON varchar(10), BASEMGR varchar(10), PRIMARY KEY (BASENUM) ); CREATE TABLE TYPE ( TYPENUM CHARACTER(1) NOT NULL, TYPEDESC varchar(30), PRIMARY KEY (TYPENUM) ); CREATE TABLE TRUCK ( TNUM CHARACTER(4) NOT NULL, BASENUM CHARACTER(3),...
I am working on this code and keep getting errors like "ERROR: Syntax error: Encountered "<EOF>" at line 1, column 169." and "ERROR: Table/View 'STUDENT' does not exist. ERROR: Table/View 'STUDENT' does not exist. ERROR: Table/View 'STUDENT' does not exist." I do not know why this isn't working. Here is my code: DTCCDatabase.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; /** * This program creates the CoffeeDB database. */ public class DTCCDatabase { public static void main(String[] args)...
/* I am executing following SQL statement for the below code but I am getting error. Pls, upload screenshot after running it. SQL Statement: SELECT OfferNo, CourseNo FROM Offering WHERE OfferTerm = 'Sum' AND OfferYear = 2012 AND FacSSN IS NULL; */ CREATE TABLE STUDENT( StdSSN INT NOT NULL PRIMARY KEY, StdFName VARCHAR2(50), StdLName VARCHAR2(50), StdCity VARCHAR2(50), StdState VARCHAR2(2), StdZip VARCHAR2(10), StdMajor VARCHAR2(15), StdYear VARCHAR2(20) ); CREATE TABLE FACULTY( FacSSN INTEGER NOT NULL PRIMARY KEY, FacFName VARCHAR(50), FacLName VARCHAR(50), FacCity...
SQL
I have a database
CREATE TABLE vendor
( vid CHAR(2) NOT NULL,
vname VARCHAR(25) NOT NULL,
PRIMARY KEY (vid) );
CREATE TABLE category
( catid CHAR(2) NOT NULL,
catname VARCHAR(25) NOT NULL,
PRIMARY KEY (catid) );
CREATE TABLE product
( pid CHAR(3) NOT NULL,
pname VARCHAR(25) NOT NULL,
price NUMERIC (7,2) NOT NULL,
vid CHAR(2) NOT NULL,
categoryid CHAR(2) NOT NULL,
PRIMARY KEY (pid));
CREATE TABLE region
( rid CHAR NOT NULL,
rname VARCHAR(25) NOT NULL,
PRIMARY KEY (rid)...
Hi I have the following Code and it Keeps giving me This Error in EDUPE: ERROR 1064 (42000) at line 1. Here is the Code I need to create a database with: DROP TABLE IF EXISTS Order; DROP TABLE IF EXISTS Customer; DROP TABLE IF EXISTS Employee; DROP TABLE IF EXISTS Payment; DROP TABLE IF EXISTS Product; DROP TABLE IF EXISTS InventoryReport; DROP TABLE IF EXISTS DistributionChannel; -- Table structure for table `Order` CREATE TABLE Order (Order_Number INT(100) PRIMARY KEY,...
Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...
Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...
Database HW help!!!!!!! Provide the SQL statements for the following queries. (1) Provide the names and phones of all swimmers currently in level (of id) 3. +-------+---------+---------------------------+ | FName | LName | EMail | +-------+---------+---------------------------+ | Bobby | Khan | theBKhan1 | | Clara | Johnson | ClaraJohnson_11 | +-------+---------+---------------------------+ 2 rows in set (0.00 sec) (2) Provide the names of swimmers who have signed up to participate in the event '100M Butterfly' of Meet id 1. +-------+---------+ | FName...
Can someone please fix my SQL SELECT code? I keep getting column ambiguously defined error. /*8. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.*/ SELECT STUDENT_ID, FIRST_NAME, LAST_NAME, GRADE_TYPE_CODE, NUMERIC_GRADE FROM STUDENT JOIN ENROLLMENT ON STUDENT.STUDENT_ID = ENROLLMENT.STUDENT_ID JOIN SECTION ON ENROLLMENT.SECTION_ID = SECTION.SECTION_ID JOIN COURSE ON SECTION.COURSE_NO = COURSE.COURSE_NO JOIN GRADE ON STUDENT.STUDENT_ID = GRADE.STUDENT_ID WHERE...