Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Update POINT field

tomascl65's profile image tomascl65 posted 5 years ago in Running SQL scripts Permalink

I'm using MariaDB 10.1.31. How to update POINT field? It works with: UPDATE table SET point_field = POINTFROMTEXT("POINT(0 0)") but not with: UPDATE table SET point_field = POINTFROMTEXT("POINT(lat_field lng_field)") Thanks.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.