SQL apply a function to all data in a column

Question

I am new to SQL. I am working on Spatialite which is a spatial database build on top of SQLite. I want to apply the function LineStringFromText() to all data in a column called "geometry". I tried the SQL statement below, but I get synax erors:

SQL error:"Near" "Select" Synax Error"

UPDATE test1f
SET geometry = SELECT LineStringFromText(geometry) from test1f

You did not share the sql statement, nor the exact error message with us. How do you expect us to help? Btw, mysql is a completely different rdbms product. Pls only use the relevant product tags. — Shadow, Jun 09 '17 at 23:27

score 0 · Accepted Answer · answered Jun 09 '17 at 23:39

0

You over-engineered it. Change this:

SET geometry = SELECT LineStringFromText(geometry) from test1f

to this

SET geometry = LineStringFromText(geometry)

answered Jun 09 '17 at 23:39

Dan Bracuk

20,699
4
26
43

SQL apply a function to all data in a column

1 Answers1