sql query not working with concat and astext

Question

SELECT LATITUDE,
       LONGITUDE, 
       AsText(concat(LATITUDE,',' ,LONGITUDE)) AS point 
FROM incident_google

query is not working for AsText

it showing result as NULL.

how to get the astext values.

if the problem is on concat or AStext.

i need result for this query.

now result as,

38.8994816000000014 -76.9785097000000036    NULL
38.9445079999999990 -77.0045459999999906    NULL

i need result as

38.8994816000000014 -76.9785097000000036    38.899481600000001476.9785097000000036

user1919238 · Accepted Answer · 2013-03-22 08:16:19Z

2

AsText() is a special function for working with columns of the geometry type.

It doesn't appear that latitude and longitude are geometry type to me; they are just floats. It should work fine if you omit AsText():

SELECT LATITUDE,LONGITUDE, concat(LATITUDE,',' ,LONGITUDE) AS point 
    FROM incident_google

SQLFiddle example.

Note: On the other hand, if you are using the geospacial extensions, you need to specify what types you are working with and what you are trying to do. This is a rather specialized area.

answered Mar 22, 2013 at 8:16

user1919238

Sign up to request clarification or add additional context in comments.

4 Comments

Aravintha Bashyam.c Over a year ago

i need to use this result value in a geometry class in java.if any other way for geometry functions.

Jhonathan H. Over a year ago

another one try to use Text() rather than AsText

user1919238 Over a year ago

@AravinthaBashyam.c, in that case just use a normal SQL query to get the values, and use the appropriate Java function to convert those values to a geometry class. How to do that would be a Java question.

user1919238 Over a year ago

@Kaii, the query above works--see the example. It is just not what the OP wants to do.

Jhonathan H. · Accepted Answer · 2013-03-22 08:15:43Z

1

Try to use Text instead of Astext first before concatinating or using CONCAT?

SELECT LATITUDE,LONGITUDE,concat(Text(LATITUDE),',' ,Text(LONGITUDE)) AS point FROM incident_google

answered Mar 22, 2013 at 8:15

Jhonathan H.

2,7131 gold badge21 silver badges28 bronze badges

2 Comments

Aravintha Bashyam.c Over a year ago

if any possible to convert this as geomentry.

Jhonathan H. Over a year ago

yes using GeomFromText() - converts string into geometry format and returns the result. GeomFromWKB -

Parisa · Accepted Answer · 2019-05-07 13:46:47Z

0

as mentioned here some of these functions has been deprecated. check here for new version names.

In newer version of MySQL (8.0+), old spatial functions like GeomFromText, AsText has been deprecated and not longer works. Make sure to follow this list from here onwords if you are facing issues with undefined function names.

answered May 7, 2019 at 13:46

Parisa

80116 silver badges37 bronze badges

Collectives™ on Stack Overflow

sql query not working with concat and astext

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related