Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    494

    Unanswered: sql error: cannot insert in db table

    What could possibly go wrong:
    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2004
    Posts
    494
    Quote Originally Posted by r937 View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •