12345678910111213141516171819 |
- -- 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;
|