Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!