Does MySQL or MariaDB support a LineString constructor that takes points?Do the type-specific WKT-...
If an area is covered in both Ball Bearings and Caltrops, does the creature need to move at half speed or quarter speed to avoid both their effects?
Why does the current not skip resistors R3 and R5 when R6 and R4 have no resistance?
Is layered encryption more secure than long passwords?
How to assess the susceptibility of a U.S. company to go bankrupt?
What happens when the last remaining players refuse to kill each other?
How can guns be countered by melee combat without raw-ability or exceptional explanations?
Does limiting the number of sources help simplify the game for a new DM with new and experienced players?
Manager has noticed coworker's excessive breaks. Should I warn him?
Not Developing a Piece in the First Five Moves
Who, if anyone, was the first astronaut to return to earth in a different vessel?
Someone wants me to use my credit card at a card-only gas/petrol pump in return for cash
Why don't hotels offer (at least) 1 kitchen bookable by any guest?
Father gets chickenpox, but doesn't infect his two children. How is this possible?
"Cheaper by the dozen" phrase origin?
Run a command that requires sudo after a time has passed
Why are recumbent bicycles and velomobiles illegal in UCI bicycle racing?
How to announce in an ATIS message that two parallel runways are in use?
Copy the content of an environment
What happens if you declare more than $10,000 at the US border?
Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?
Do error bars on probabilities have any meaning?
How to not forget my phone in the bathroom?
Prove that a cyclic group with only one generator can have at most 2 elements
Can you make a Spell Glyph of a spell that has the potential to target more than one creature?
Does MySQL or MariaDB support a LineString constructor that takes points?
Do the type-specific WKT- constructors function differently from ST_GeomFromText?Does MariaDB Support Materialized views?Mariadb alongside MySQL Can't start the MariaDBST_Distance_Spheroid does not existSQL Server Point Constructor or version of ST_Point(x,y)?SQL Server Line Constructor or version of ST_MakeLine(pt1,pt2)?ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDBDoes MariaDB support ST_Distance_Sphere?Storing point data for linestring in MySQLDoes MySQL or MariaDB support GIS KNN Index Queries (k-nearest neighbors)?mysql trigger not allowing to select from another table
It seems with MySQL and MariaDB I'm getting the following when I try to use the LineString constructor. In PostGIS I can do this with ST_MakeLine(pt1,pt2)
> SELECT ST_MakeLine(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_MakeLine does not exist
> SELECT ST_LineString(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_LineString does not exist
Is the only way to construct a LINESTRING to use ST_GeomFromText or ST_LineFromText, or ST_LineStringFromText?
mysql mariadb spatial mysql-8.0
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
add a comment |
It seems with MySQL and MariaDB I'm getting the following when I try to use the LineString constructor. In PostGIS I can do this with ST_MakeLine(pt1,pt2)
> SELECT ST_MakeLine(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_MakeLine does not exist
> SELECT ST_LineString(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_LineString does not exist
Is the only way to construct a LINESTRING to use ST_GeomFromText or ST_LineFromText, or ST_LineStringFromText?
mysql mariadb spatial mysql-8.0
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
add a comment |
It seems with MySQL and MariaDB I'm getting the following when I try to use the LineString constructor. In PostGIS I can do this with ST_MakeLine(pt1,pt2)
> SELECT ST_MakeLine(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_MakeLine does not exist
> SELECT ST_LineString(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_LineString does not exist
Is the only way to construct a LINESTRING to use ST_GeomFromText or ST_LineFromText, or ST_LineStringFromText?
mysql mariadb spatial mysql-8.0
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
It seems with MySQL and MariaDB I'm getting the following when I try to use the LineString constructor. In PostGIS I can do this with ST_MakeLine(pt1,pt2)
> SELECT ST_MakeLine(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_MakeLine does not exist
> SELECT ST_LineString(Point(0,0), Point(0,1));
ERROR 1305 (42000): FUNCTION ST_LineString does not exist
Is the only way to construct a LINESTRING to use ST_GeomFromText or ST_LineFromText, or ST_LineStringFromText?
mysql mariadb spatial mysql-8.0
mysql mariadb spatial mysql-8.0
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
edited 1 hour ago
Evan Carroll
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
asked 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
32.4k970220
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
No, as a general rule the constructors for MySQL are only available with non-ST_ prefixes.
So you'll want LineString(pt1,pt2)
SELECT LineString(Point(0,0), Point(0,1));
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230189%2fdoes-mysql-or-mariadb-support-a-linestring-constructor-that-takes-points%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
No, as a general rule the constructors for MySQL are only available with non-ST_ prefixes.
So you'll want LineString(pt1,pt2)
SELECT LineString(Point(0,0), Point(0,1));
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
add a comment |
No, as a general rule the constructors for MySQL are only available with non-ST_ prefixes.
So you'll want LineString(pt1,pt2)
SELECT LineString(Point(0,0), Point(0,1));
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
add a comment |
No, as a general rule the constructors for MySQL are only available with non-ST_ prefixes.
So you'll want LineString(pt1,pt2)
SELECT LineString(Point(0,0), Point(0,1));
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
No, as a general rule the constructors for MySQL are only available with non-ST_ prefixes.
So you'll want LineString(pt1,pt2)
SELECT LineString(Point(0,0), Point(0,1));
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
answered 1 hour ago
Evan CarrollEvan Carroll
32.4k970220
32.4k970220
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230189%2fdoes-mysql-or-mariadb-support-a-linestring-constructor-that-takes-points%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
