Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "data":
- [
- {
- "id": "1001",
- "posng_valid_type": null,
- "longitude": 121.178545,
- "latitude": 31.30523,
- "heading": 0,
- "altitude": 100.564,
- "gps_speed": 0,
- "sample_time": "0000-00-00 00:00:00",
- "update_time": "2017-02-17 01:06:58"
- }
- ]
- }
- ======插入DB的SQL
- INSERT INTO `status_position` (`id`, `posng_valid_type`, `longitude`, `latitude`, `heading`, `altitude`, `gps_speed`, `sample_time`, `update_time`)
- VALUES
- ('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