mysql语句记录

水位项目

select
p.project_id,
p.project_name,
pt.project_type_name,
p.createtime
from
project p inner join project_type pt on p.project_type_id=pt.project_type_id
where p.user_id=@1-USER_ID@ and p.status=1;

修改

UPDATE project SET
project_name = @15-PROJECT_NAME@
, project_type_id = @15-PROJECT_TYPE_NAME@
WHERE project_id=@11-PROJECT_ID@;

水位查看

SELECT w.sensor_group_name, w.sensor_sn, s.sensor_name, w.test_dt, w.test_data FROM water_data w inner join sensor s on w.sensor_sn=s.sensor_sn WHERE w.id IN(SELECT MAX(id) FROM water_data GROUP BY sensor_sn ) and w.project_id=@9-project_id_select@ ORDER BY s.sensor_name ASC ;