title: Syntax error 1064 in CREATE TABLE statement with TINYTEXT columns?
body: <p>This is the MySQL code I have so far:</p>
  
  <pre><code>CREATE DATABASE bankbase;
  
  USE bankbase;
  
  CREATE TABLE clienttable(
  ClientID SMALLINT(15) NOT NULL DEFAULT 0,
  ClientFirstName VARCHAR(30) NOT NULL DEFAULT "first name",
  ClientLastName VARCHAR(30) NOT NULL DEFAULT "last name",
  ClientPhone CHAR(10) NOT NULL, ClientEmail 
  
  TINYTEXT(30) NULL,
  ClientAddress TINYTEXT(128) NOT NULL,
  PRIMARYKEY(ClientID)
  );
  
  CREATE TABLE branchtable(
  BranchID SMALLINT(15) NOT NULL DEFAULT 0,
  BranchCity TINYTEXT(30) NOT NULL DEFAULT city, 
  
  BranchManagerFName VARCHAR(30) NULL DEFAULT "Branch Manager's First Name",
  BranchManagerLName VARCHAR(30) NULL 
  
  DEFAULT "Branch Manager's LAst Name",
  BranchPhone CHAR(10) NOT NULL,
  BranchEmail TINYTEXT(30) NULL DEFAULT @bank.com,
  PRIMARYKEY(BranchID)
  );
  
  CREATE TABLE transactiontable(
  TypeID SMALLINT(15) NOT NULL DEFAULT 0,
  Type ENUM('CHEQUING','SAVINGS') NOT NULL,
  TransAmount DECIMAL NOT NULL,
  TransDate TIMESTAMP NOT NULL,
  Balance DOUBLE NOT NULL,
  PRIMARYKEY(TypeID)
  );
  </code></pre>
  
  <p>Running this code in MySQL on the command line gives me this error:</p>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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 '(TypeID)
            )' at line 7</p>
  </blockquote>
  
  <p>I've tried creating different test tables, leaving out the NULL/NOT NULL, but nothing seems to work. Any help would be very, very appreciated!</p>