我的解决方案是发出一系列查询，每行一个，并用联合将它们绑定在一起。mysql堆栈最终会崩溃，所以您需要分块执行，但默认安装1000就可以了。您必须将查询括起来，因为它们包含order by。有些点可能会失败，所以我给它们都贴上了文字行的标签，这样你就可以编辑和过滤原稿了。您还需要使用

WHERE Contains(<polygon>,point)

子句，否则它将尝试对整个表进行排序，其中polygon是一个边界框，您必须使用geomfromtext（）和polygon（）进行处理。当然，在列上还需要一个特殊的空间索引！。这里有一些代码

var SMALL=0.001
            var=query=points
                .map(function(point){
                    var bottom=point.lat+SMALL
                    var top=point.lat-SMALL
                    var left=point.lon-SMALL
                    var right=point.lon+SMALL
                    var polygon=[
                        [bottom,left],
                        [top,left],
                        [top,right],
                        [bottom,right],
                        [bottom,left]
                    ]
                    polygon="POLYGON(("+polygon.map(function(point){
                        return point.join(' ')
                    })
                    .join(",")+"))"
                    point.line_no=line_no++
                    return "(SELECT "+point.line_no+" as line_no,id, ST_Distance(POINT("+
                                point.lat+","+point.lon+
                                "),geo_point) as distance"+
                                " from Points "+
                                " WHERE Contains(GeomFromText('"+polygon+"'),geo_point) "+
                                " order by distance limit 1) "
                })
                .join(" UNION ")+" order by line_no"
            return sequelize.query(query)

这可能适合您：

SELECT t.id as tid, p.id as pid, p.geo_point
FROM TempPoint t
JOIN Points p ON p.id = (
    SELECT p1.id
    FROM Points p1
    ORDER BY ST_Distance(p1.geo_point, t.geo_point)
    LIMIT 1
)