DELIMITER //
CREATE TRIGGER listing_id 
BEFORE INSERT ON listings
FOR EACH ROW 
BEGIN
SET NEW.lastupdated = NOW();
END;//
DELIMITER ;