sql error: cannot insert in db table

gilgalbiblewhee · #1 (**permalink**) 03-31-11, 11:21

What could possibly go wrong:

Quote:

INSERT INTO bible (book', 'book_spoke', 'recordType', 'book_title', 'chapter', 'chapter_spoke', 'verse', 'verse_spoke', 'text_data) VALUES ('1', '1', 'gn', 'Genesis', '1', '1', '1', '1', 'In the beginning God created the heaven and the earth.')
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 '', 'book_spoke', 'recordType', 'book_title', 'chapter', 'chapter_spoke', 'verse'' at line 1

r937 · #2 (**permalink**) 03-31-11, 11:37

the error message is telling you ~exactly~ where to look for the source of the error

INSERT INTO bible (book', 'book_spoke', 'recordType', ..

right there, in red

by the way, you can insert values into columns, but you can not insert values into strings

gilgalbiblewhee · #3 (**permalink**) 03-31-11, 12:09

Quote:

Originally Posted by r937

the error message is telling you ~exactly~ where to look for the source of the error

INSERT INTO bible (book', 'book_spoke', 'recordType', ..

right there, in red

by the way, you can insert values into columns, but you can not insert values into strings

Oh yeah! That's right! Thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech