Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- localhost 5.5.33-0+wheezy1:test mysql> CREATE TABLE geom (g GEOMETRY);
- Query OK, 0 rows affected (0.11 sec)
- localhost 5.5.33-0+wheezy1:test mysql> INSERT INTO geom (g)
- -> VALUES(PolygonFromText('POLYGON((
- '> 9.190586853 45.464518970,
- '> 9.190602686 45.463993916,
- '> 9.191572471 45.464001929,
- '> 9.191613325 45.463884676,
- '> 9.192136130 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.464647090,
- '> 9.191622331 45.464506215,
- '> 9.190586853 45.464518970))')
- -> );
- Query OK, 1 row affected (0.10 sec)
- localhost 5.5.33-0+wheezy1:test mysql> SELECT g FROM geom;
- +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | g |
- +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | 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"@���
- 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@ |
- +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
- localhost 5.5.33-0+wheezy1:test mysql> SELECT asText(g) FROM geom;
- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | asText(g) |
- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | 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)) |
- +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement