DECLARE var1 DATETIME; DECLARE var2 DATETIME; SELECT t.f1, t.f2 into var1,var2 FROM tableName t ; SELECT class_id1, attend_time1, finish_time1 ;