Question

I keep getting this error "You have an error in your SQL syntax; check the manual...

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),

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

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.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
I keep getting this error "You have an error in your SQL syntax; check the manual...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Assume the following employees.sql file: create table employees (    id INTEGER NOT NULL PRIMARY KEY...

    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...

    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>"...

    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....

    /* 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...

    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...

    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...

    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...

    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...

    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....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT