title: Sqlite Playing Cards Table
body: <p>I'm learning SQL by using Sqlite. I want to create a simple deck of playing cards using Sqlite. My attempt is below.</p>
  
  <p>Because I kept getting syntax errors I tried letting <code>DB browser for Sqlite</code> create the code to create the table by adding the fields manually. Now I'm left with some kind of hybrid syntax and I can't identify what the problems is when I put it through a syntax checker.</p>
  
  <p>If I try and insert just one line:</p>
  
  <pre><code>INSERT INTO cards (name, suit, suit_symbol, score) VALUES (
  
      -- Spades
      ("A", "spades", "♠", 1)
    );
  </code></pre>
  
  <p>I get <code>Uncaught Error: 1 values for 4 columns</code></p>
  
  <p>If I try and run the whole thing, I get <code>Uncaught Error: near ")": syntax error</code></p>
  
  <p>I'm guessing there's at least two problems with my code, and part of the difficulty is that I have already learned a little MySQL which seems to be subtly and confusingly different.</p>
  
  <p>Any help with getting my table built successfully in Sqlite and understanding why it doesn't work as is would be much appreciated.</p>
  
  <pre><code>--CREATE DATABASE IF NOT EXISTS cards;
  
  CREATE TABLE IF not exists "cards" (
      "id"    INTEGER PRIMARY KEY AUTOINCREMENT,
      "name"  TEXT,
      "suit"  TEXT,
      "suit_symbol"   TEXT,
      "score" INTEGER
  );
  
  INSERT INTO cards (name, suit, suit_symbol, score) VALUES (
  
      -- Spades
      ("A", "spades", "♠", 1), 
      ("2", "spades", "♠", 2), 
      ("3", "spades", "♠", 3), 
      ("4", "spades", "♠", 4), 
      ("5", "spades", "♠", 5), 
      ("6", "spades", "♠", 6), 
      ("7", "spades", "♠", 7), 
      ("8", "spades", "♠", 8), 
      ("9", "spades", "♠", 9), 
      ("10", "spades", "♠", 10), 
      ("J", "spades", "♠", 11), 
      ("Q", "spades", "♠", 12), 
      ("K", "spades", "♠", 13), 
  
      -- Hearts
      ("A", "hearts", "♥", 1), 
      ("2", "hearts", "♥", 2), 
      ("3", "hearts", "♥", 3), 
      ("4", "hearts", "♥", 4), 
      ("5", "hearts", "♥", 5), 
      ("6", "hearts", "♥", 6), 
      ("7", "hearts", "♥", 7), 
      ("8", "hearts", "♥", 8), 
      ("9", "hearts", "♥", 9), 
      ("10", "hearts", "♥", 10), 
      ("J", "hearts", "♥", 11), 
      ("Q", "hearts", "♥", 12), 
      ("K", "hearts", "♥", 13), 
  
      -- Clubs
      ("A", "clubs", "♣", 1), 
      ("2", "clubs", "♣", 2), 
      ("3", "clubs", "♣", 3), 
      ("4", "clubs", "♣", 4), 
      ("5", "clubs", "♣", 5), 
      ("6", "clubs", "♣", 6), 
      ("7", "clubs", "♣", 7), 
      ("8", "clubs", "♣", 8), 
      ("9", "clubs", "♣", 9), 
      ("10", "clubs", "♣", 10), 
      ("J", "clubs", "♣", 11), 
      ("Q", "clubs", "♣", 12), 
      ("K", "clubs", "♣", 13), 
  
      -- Diamonds
      ("A", "diamonds", "♦", 1), 
      ("2", "diamonds", "♦", 2), 
      ("3", "diamonds", "♦", 3), 
      ("4", "diamonds", "♦", 4), 
      ("5", "diamonds", "♦", 5), 
      ("6", "diamonds", "♦", 6), 
      ("7", "diamonds", "♦", 7), 
      ("8", "diamonds", "♦", 8), 
      ("9", "diamonds", "♦", 9), 
      ("10", "diamonds", "♦", 10), 
      ("J", "diamonds", "♦", 11), 
      ("Q", "diamonds", "♦", 12), 
      ("K", "diamonds", "♦", 13), 
      );
  </code></pre>