Cannot find MySQL syntax error

Question

MySQL gives me syntax error for a simple query but I don't see any error. If you guys find any please help.

insert into cast(sid,celeb_id,type,name,prior)
  values(30,1,1,'James Keziah Delaney',2)

It gives sql syntax error near cast.

Answer 1

The main cause of this error is that there is a function Cast in mysql.

It look like to call the cast() function.

You can choose one of the solutions to solve it.

1. add ` to contain cast table name

look like this.

insert into `cast`(sid,celeb_id,type,name,prior) values(30,1,1,'James Keziah Delaney',2)

sqlfiddle

2. add a space between cast and ( let mysql know you did't want to execute Cast method. thank for @Barmar remind.

Note:

I would suggest you don't give the table name from keyword or function name.

Answer 2

You can't insert into cast(). It requires a list of column names.