UPDATE `comp_supplier_invoice` SET `projectID` = '', `termsID` = '6', `invoiceDate` = '2015-07-14', `memo` = '', `supplierInvoiceNo` = 'LUBRICANT FOR JULY', `formNo` = 'PI' WHERE `ID` =  '12'