UPDATE walkers set latitude = '', longitude = '', realdistance = '', virtualdistance = '', timestamp = NOW(), speed = '', yaw = '' where username = '' and walkname = '' INSERT into footprints values ('', '', '', '', '', '', '', '', NOW())