title: MySQl Error #1064
body: <p>I keep getting this error:</p>
  
  <blockquote>
    <p>MySQL said: #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 'INSERT INTO
    books.book(isbn10,isbn13,title,edition,author_f_name,author_m_na'
    at line 15</p>
  </blockquote>
  
  <p>with this query:</p>
  
  <pre><code>USE books;
  
  DROP TABLE IF EXISTS book;
  
  
      CREATE TABLE `books`.`book`(
      `book_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
      `isbn10` VARCHAR(15) NOT NULL,
      `isbn13` VARCHAR(15) NOT NULL,
      `title` VARCHAR(50) NOT NULL,
      `edition` VARCHAR(50) NOT NULL,
      `author_f_name` VARCHAR(50) NOT NULL,
      `author_m_name` VARCHAR(50) NOT NULL,
      `author_l_name` VARCHAR(50) NOT NULL,
      `cond` ENUM('as new','very good','good','fair','poor') NOT NULL,
      `price` DECIMAL(8,2) NOT NULL,
      `genre` VARCHAR(50) NOT NULL,
      `quantity` INT NOT NULL)
  
      INSERT INTO books.book(isbn10,isbn13,title,edition,author_f_name,author_m_name,author_l_name,cond,price,genre,quantity)** 
      VALUES ('0136061699','978-0136061694','Software Engineering: Theory and Practice','4','Shari','Lawrence','Pfleeger','very good','50','Computing','2');
  </code></pre>
  
  <p>Any idea what the problem is?</p>