Skip to content

Instantly share code, notes, and snippets.

@luiscberrocal

luiscberrocal/insert_route_data.sql

Created January 11, 2012 14:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save luiscberrocal/1594781 to your computer and use it in GitHub Desktop.
Save luiscberrocal/1594781 to your computer and use it in GitHub Desktop.
Download ZIP
Insert route data for web service tutorial
Raw
insert_route_data.sql
INSERT INTO `mroute` (`id`, `name`) VALUES
(1, 'Route 1-2'),
(2, 'Route 2-3'),
(3, 'Route 4-5');
INSERT INTO `point` (`id`, `route_id`, `name`, `x`, `y`, `pType`) VALUES
(1, 1, 'Punto 1', '-79.125', '9.08', 'STOP'),
(2, 1, 'Punto 2', '-79.185', '9.12', 'STOP'),
(3, 2, 'Punto 3', '-79.122', '9.081', 'STOP'),
(4, 2, 'Punto 4', '-79.142', '9.092', 'STOP');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment