cow.sql 494 B

12345678910111213141516171819
  1. -- insert into message_type (sys_name,pasture_id,service_id,remind_type)
  2. -- values
  3. -- ('cow',1,1,1);
  4. -- select distinct id,template_id from message_type;
  5. -- select * from message_type order by id desc limit 1;
  6. -- update
  7. -- message_type
  8. -- set
  9. -- type_name ='cowtst',
  10. -- template_id = 'RLPlaCnqQZt_6s4HZuaFJYbQ9gmTfIYipTYDoKJInY8'
  11. -- where
  12. -- id = 36;
  13. -- delete from message where status =0;
  14. select * from message where status= 0;
  15. -- select
  16. -- *
  17. -- from
  18. -- message_type;