Advertisement
Guest User

Untitled

a guest
Mar 6th, 2014
610
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.94 KB | None | 0 0
  1. localhost 5.5.33-0+wheezy1:test mysql> CREATE TABLE geom (g GEOMETRY);
  2. Query OK, 0 rows affected (0.11 sec)
  3.  
  4. localhost 5.5.33-0+wheezy1:test mysql> INSERT INTO geom (g)
  5. -> VALUES(PolygonFromText('POLYGON((
  6. '> 9.190586853 45.464518970,
  7. '> 9.190602686 45.463993916,
  8. '> 9.191572471 45.464001929,
  9. '> 9.191613325 45.463884676,
  10. '> 9.192136130 45.463880767,
  11. '> 9.192111509 45.464095594,
  12. '> 9.192427961 45.464117804,
  13. '> 9.192417811 45.464112862,
  14. '> 9.192509035 45.464225851,
  15. '> 9.192493139 45.464371079,
  16. '> 9.192448471 45.464439002,
  17. '> 9.192387444 45.464477861,
  18. '> 9.192051402 45.464483037,
  19. '> 9.192012814 45.464643592,
  20. '> 9.191640825 45.464647090,
  21. '> 9.191622331 45.464506215,
  22. '> 9.190586853 45.464518970))')
  23. -> );
  24. Query OK, 1 row affected (0.10 sec)
  25.  
  26. localhost 5.5.33-0+wheezy1:test mysql> SELECT g FROM geom;
  27. +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  28. | g |
  29. +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  30. | x]���a"@�B�[u�F@��ݬ�a"@�a'd�F@��s�b"@�*Kjd�F@��H$"@�D��`�F@�u��_b"@��q`�F@0��p\b"@N9|g�F@t����b"@��R6h�F@i�Z��b"@���
  31. h�F@�S��b"@[ ��k�F@4k�u�b"@����p�F@m8"��b"@�I��r�F@5Hh��b"@[�t�F@^{��Tb"@.t�F@���Ob"@���py�F@,��b"@��K�y�F@�yRb"@\�t�F@x]���a"@�B�[u�F@ |
  32. +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  33. 1 row in set (0.00 sec)
  34.  
  35. localhost 5.5.33-0+wheezy1:test mysql> SELECT asText(g) FROM geom;
  36. +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  37. | asText(g) |
  38. +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  39. | POLYGON((9.190586853 45.46451897,9.190602686 45.463993916,9.191572471 45.464001929,9.191613325 45.463884676,9.19213613 45.463880767,9.192111509 45.464095594,9.192427961 45.464117804,9.192417811 45.464112862,9.192509035 45.464225851,9.192493139 45.464371079,9.192448471 45.464439002,9.192387444 45.464477861,9.192051402 45.464483037,9.192012814 45.464643592,9.191640825 45.46464709,9.191622331 45.464506215,9.190586853 45.46451897)) |
  40. +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement