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
Get step-by-step solutions from verified subject matter experts
