My CREATE TABLE list seems not to work

My CREATE TABLE list seems not to work... I've used this before or so I thought with no issue. Can anyone here find out what my issue is? I've gone through my books, they look identical... at least in format. So I don't know what I am missing, can anyone see what I've missed?

Thanks

CREATE TABLE 'ncmr' (
    'id' INT AUTO_INCREMENT,
    'Added_By' VARCHAR(80),
    'Added_By_Date' DATE
    'Nexx_Part' VARCHAR(60),
    'Nexx_Part_Description' VARCHAR(90),
    'NCMR_Qty' VARCHAR(20),
    'JO' VARCHAR(20),
    'SN' VARCHAR(20),
    'INV' VARCHAR(20),
    'Nexx_Inventory_On_Hand' VARCHAR(20),
    'Nexx_Inventory_Chk' VARCHAR(20),
    'Supplier_Name' VARCHAR(60),
    'Supplier_Number' VARCHAR(60),
    'Manufacturer_Part_Number' VARCHAR(60),
    'Manufacturer_Serial_Number' VARCHAR(60),
    'NCMR_ID' VARCHAR(20),
    'Nonconformity' MEDIUMTEXT,
    'Disposition' MEDIUMTEXT,
    'Comments' MEDIUMTEXT,
    'CommentsAdditional_Details' MEDIUMTEXT,
    'PO' VARCHAR(20),
    'PO_Date' DATE,
    'Date_Received' DATE,
    'ncmrsr' MEDIUMTEXT,
    'ncmrsc' MEDIUMTEXT,
    PRIMARY KEY ('id')
);



INSERT INTO ncmr VALUES (
'1',
'Peter Teigeler',
'7/7/2011',
'K11205368',
'1',
'Assy, CMM Module w/window & Cover',
'2',
'I8778',
'164',
'N/A',
'N/A',
'Plastic Design Inc',
'100255',
'K11205386',
'N/A',
'N/A',
'1054',
'Not made to print, missing 2 proximity sensor mouting brackets. These need to be welded in place.',
'Return to vendor for rework, or have vendor come in and rework on site.'
);

Code (markup):

 

Hi Matt.

1. Replace ' with ` in your CREATE TABLE query.
2. Put comma after 'Added_By_Date' DATE

Once you fix those issues table should be created fine, and you will be able to check if your insert query works fine