Inserting into table using Python and MySQLdb

Question

I am using Python and MySQLdb, I have a table which is displayed below but I get error message each time I try to insert into the table.

INSERT INTO reviews (entry,created_time, user_id, branch_id, title)VALUES('branches that would lead use to the ciyrt', '2011-09-20 00:24:24',1, ,1, 'oogletivers')

   CREATE TABLE reviews
   (
     id int(9)  unsigned not null  primary key auto_increment,
 entry text  not null , 
 created_time timestamp not null,
 user_id tinyint unsigned  not null references users(id),
 branch_id tinyint unsigned not null references branches( id),
 title varchar(255),
 FULLTEXT(title, entry)
      )

mysql_exceptions.ProgrammingError: (1064, "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 '1, 'oogletivers')' at line 1")

Ignacio Vazquez-Abrams · Accepted Answer · 2011-09-25 05:57:04Z

1

You have two commas without anything between them. Remove one.

answered Sep 25, 2011 at 5:57

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user618677 Over a year ago

Thanks, I can't believe that I could miss that.

Collectives™ on Stack Overflow

Inserting into table using Python and MySQLdb

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related