mysql

UPDATE 后面接SELECT的用法
update facility_info set facility_num = 1 where create_time = ( select a.create_time from (select min(create_time) as create_time from facility_info) a);

select id,name,facility_num,create_time from facility_info where facility_num = 1 and create_time = (select min(create_time) from facility_info);