Adding rows to a MySql table

[admin]

Hi,

I have a small problem, I have been trying to add a row to a table, and just cant seem to do it.


The table is as follows:

mysql> describe TblPressRelease;
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| MLgName | varchar(45) | YES | | NULL | |
| PressReleaseID | int(11) | | PRI | 0 | auto_increment |
| SubDt | date | YES | | NULL | |
| Heading | varchar(70) | YES | | NULL | |
| SubHeading | varchar(150) | YES | | NULL | |
| Body | longtext | YES | | NULL | |
| ArchDt | date | YES | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

I have tried the following (and about 1000 different variations)

insert into TblPressRelease (Field,Type, Null, Key, Default, Extra)
-> values ('Email', 'varchar(45)', 'YES', 'null', 'null', 'null', 'null');

As you can see I need to add a row called 'Email' with a type of varchar(45)

As a newbie to SQL I dont really have any idea as to why this isnt working. Any help would be appreciated.

Thank You

Mark Rendell