Question

我怎么能把这个从MS SQLSERVER转换成 MySQL?

/****** Object: StoredProcedure [dbo].[geolocation_refresh_geography] Script Date: 05/08/2012 22:02:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[geolocation_refresh_geography]
as
update locations
SET geolocation = geography::STPointFromText( POINT(  + CAST([Longitude] AS VARCHAR(20)) +     + CAST([Latitude] AS VARCHAR(20)) +  ) , 4326)
where geolocation is null
GO

我的代码在4线造成错误不知道为什么?

create procedure geolocation_refresh_geography()
BEGIN
update locations
SET geolocation = geography::STPointFromText( POINT(  + CAST(Longitude AS VARCHAR(20)) +     + CAST(Latitude AS VARCHAR(20)) +  ) , 4326)
where geolocation is null
END

Answer 1

你试过《MySQL移徙工具包》了吗?

http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-integration-inte-spolictedb-msql.html

It is a bit tough to find these days but I believe you can also you MySQL Workbench to accomplish this. http://www.mysql.com/products/workbench/

我建议你将整个计划移走,这样你就可以完成这个程序了

Answer 2

首先, MySQL 支持空间数据, 前提是启用空间扩展功能配置( http://dev. mysql.com/doc/refman/ 5. 0/ en/ spatial- extensions. html ) 。假设您已经安装了这个设置, 您只需要将 SQL 服务器语法调整为适合的 MySQL 方法即可。

MySQL 拥有一个 PointFromText () 方法( http://dev. mysql.com/doc/ dec/ refman/ 5. 0/ en/ create- spatial- values.html#conference_point fromtext ()), 反映 SQL 服务器 STPointFromText () 的行为( http:// msdn. microsoft. com/ en- us/library/b933979.aspx), 这样您就可以用 PointFlookText 来取代“ em> em/ em:: STPointFromText 的引用。

然而,对于在单一纬度/纬度坐标对上插入点,如您所做的那样,最容易使用的方法是Point () (http://dev.mysql.com/doc/refman/5.0/en/create-spatial-values.html#conference_point),在这种情况下,您的代码就变成:

create procedure geolocation_refresh_geography()
BEGIN
update locations
SET geolocation = Point(Longitude, Latitude)
where geolocation is null
END

友情链接