Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. {
  2. "data":
  3. [
  4. {
  5. "id": "1001",
  6. "posng_valid_type": null,
  7. "longitude": 121.178545,
  8. "latitude": 31.30523,
  9. "heading": 0,
  10. "altitude": 100.564,
  11. "gps_speed": 0,
  12. "sample_time": "0000-00-00 00:00:00",
  13. "update_time": "2017-02-17 01:06:58"
  14. }
  15. ]
  16. }
  17.  
  18. ======插入DB的SQL
  19. INSERT INTO `status_position` (`id`, `posng_valid_type`, `longitude`, `latitude`, `heading`, `altitude`, `gps_speed`, `sample_time`, `update_time`)
  20. VALUES
  21. ('1001', NULL, 121.178545, 31.305230, 0, 100.564, 0, '0000-00-00 00:00:00', '2017-02-17 01:06:58');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement