UPDATE `assignment1`.`properties` WHERE 'property_ID' = 11 ( `PROPERTY_ID` ,`property_class` ,`property_manager` ,`property_street_number` ,`property_street_name` ,`property_suburb` ,`property_post_code` ,`latitude` ,`longitude` ,`rent_per_week` ,`date_let` ,`date_lease_expire` ,`bedrooms` ,`bathrooms` ,`parking` ,`owner_name` ,`owner_contact` ,`owner_street_number` ,`owner_street_name` ,`owner_suburb` ,`owner_post_code` ) VALUES ( '11' , 'R', 'sadaus', '121', 'A street name', 'Broadview', '5020', '666', '414', '315', '2008-08-15', '2009-08-15', '3', '2', '3', 'Joe Citizen', '987654321', '32', 'citizen rd', 'sims town', '4545' )