MySQL Create table syntax error

Question

CREATE TABLE plan 
  ( 
     id                VARCHAR(30) NOT NULL, 
     name              VARCHAR(20), 
     amount            INT, 
     interval          INT, 
     currency          CHAR(3), 
     object            VARCHAR(20), 
     livemode          BOOLEAN, 
     interval_count    INT, 
     trial_period_days INT, 
     created           TIMESTAMP, 
     updated           TIMESTAMP, 
     deleted           TIMESTAMP, 
     PRIMARY KEY (id) 
  ); 

Produces

'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 'interval          INT, 
     currency          CHAR(3), 
     object            ' at line 6'

Doesn't work. However if the 'l' at the end of 'interval' is removed. It works.

CREATE TABLE plan 
  ( 
     id                VARCHAR(30) NOT NULL, 
     name              VARCHAR(20), 
     amount            INT, 
     interva           INT, 
     currency          CHAR(3), 
     object            VARCHAR(20), 
     livemode          BOOLEAN, 
     interval_count    INT, 
     trial_period_days INT, 
     created           TIMESTAMP, 
     updated           TIMESTAMP, 
     deleted           TIMESTAMP, 
     PRIMARY KEY (id) 
  ); 

I don't understand if this is a problem with attempting to use 'interval' and 'interval_count'. What's going on here.

Answer 1

The word "interval" is a reserved word. You can still use it if you quote it correctly.

See the MySQL Manual for a list of the reserved words and how to use them. In fact, "interval" is the first example in the link provided:

mysql> CREATE TABLE interval (begin INT, end INT);
ERROR 1064 (42000): You have an error in your SQL syntax ...
near 'interval (begin INT, end INT)'

mysql> CREATE TABLE `interval` (begin INT, end INT);
Query OK, 0 rows affected (0.01 sec)