Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. {
  2. "data":
  3. [
  4. {
  5. "id": "1011",
  6. "win_frnt_le_posn": 84,
  7. "win_frnt_ri_posn": 60,
  8. "win_re_le_posn": 70,
  9. "win_re_ri_posn": 80,
  10. "sun_roof_posn": 90,
  11. "sun_roof_shade_posn": 99,
  12. "sample_time": "2017-03-06 10:53:58",
  13. "update_time": "2017-03-06 10:53:58"
  14. }
  15. ]
  16. }
  17.  
  18. =======插入DB的SQL
  19. INSERT INTO `status_window` (`id`, `win_frnt_le_posn`, `win_frnt_ri_posn`, `win_re_le_posn`, `win_re_ri_posn`, `sun_roof_posn`, `sun_roof_shade_posn`, `sample_time`, `update_time`)
  20. VALUES
  21. ('1011', 84, 60, 70, 80, 90, 99, '2017-03-06 10:53:58', '2017-03-06 10:53:58');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement