mysql> show tables;
+-------------------------+
| Tables_in_TICKETBOOKING |
+-------------------------+
| EVENTS                  |
| PERFORMANCE             |
| VENUE                   |
+-------------------------+
3 rows in set (0.00 sec)


mysql> describe VENUE;
+-----------+--------------+------+-----+-------------------+----------------+
| Field     | Type         | Null | Key | Default           | Extra          |
+-----------+--------------+------+-----+-------------------+----------------+
| venueid   | int(11)      | NO   | PRI | NULL              | auto_increment |
| venuename | varchar(100) | YES  |     | NULL              |                |
| created   | timestamp    | NO   |     | CURRENT_TIMESTAMP |                |
+-----------+--------------+------+-----+-------------------+----------------+
3 rows in set (0.00 sec)


mysql> insert into VENUE(venuename) values("Village 4");
Query OK, 1 row affected (0.00 sec)

mysql> select * from VENUE;
+---------+--------------------------+---------------------+
| venueid | venuename                | created             |
+---------+--------------------------+---------------------+
|       1 | location1                | 2013-04-01 21:33:51 |
|       2 | location2                | 2013-04-01 21:33:55 |
|       3 | Salem Longford Hall      | 2013-04-01 21:34:08 |
|       4 | Alderman's Green FM Hall | 2013-04-01 21:34:24 |
|       5 | Village 1                | 2013-04-01 21:34:41 |
|       6 | Village 2                | 2013-04-01 21:34:43 |
|       7 | Village 3                | 2013-04-01 21:34:46 |
|       8 | Village 4                | 2013-04-01 21:34:48 |
+---------+--------------------------+---------------------+
8 rows in set (0.00 sec)

mysql>