title: I cant solve error in database
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/11675148/i-have-mistake-in-database">I have mistake in database</a>  </p>
  </blockquote>
  
  
  
  <pre><code>create table Ticket (
  ticket_id integer not null primary key,
  AirlineName varchar not null,
  CustomerName varchar,
  fromCity varchar,
  toCity varchar,
  fltNo integer,
  TicketDate date,
  Dtime TIME,
  Atime time,
  price integer);
  </code></pre>
  
  <p>Please help me, I can't find the error.
  the program is my sql, and this is the error</p>
  
  <p>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 'not null,
  CustomerName varchar,
  fromCity varchar,
  toCity varchar,
  fltNo inte' at line 3</p>