-- insert into message_type (sys_name,pasture_id,service_id,remind_type) -- values -- ('cow',1,1,1); -- select distinct id,template_id from message_type; -- select * from message_type order by id desc limit 1; -- update -- message_type -- set -- type_name ='cowtst', -- template_id = 'RLPlaCnqQZt_6s4HZuaFJYbQ9gmTfIYipTYDoKJInY8' -- where -- id = 36; -- delete from message where status =0; select * from message where status= 0; -- select -- * -- from -- message_type;