Use 3d pythagorean theorem.
the distance d between point1 (x1,y1,z1) and point2 (x2,y2,z2) is...
d = sqrt((x1-x2)^2 + (y1-y2)^2 + (z1-z2)^2)
as for building an index for this? i have no idea. but that is how you
find the distance between two 3D points.
b
Jose Antonio wrote:
MySQL offers Sp
Hello.
For a pity, I do not have an exact answer on how to do your task in a
best way with MySQL. Searching in the archives gave me these links:
http://lists.mysql.com/mysql/185851
http://lists.mysql.com/mysql/185846
Perhaps, you will need the help of stored routines or UDFs:
http://dev.mys
MySQL offers Spacial Extensions to operate with points in a 2 dimensional
space.
For a project I'm working on, I need to work with points in an N dimensional
space and measure the distance among them. Is there a clever do to solve the
following problem?:
Let's say I have 4 3D point (X,Y,Z):
(0,0
