CREATE PROCEDURE `getAssetDetailsforPDF`(
) BEGIN
Select
    class.Name as AssetName,
    getOperatingZoneName(
        ifnull(getoperatingzone(class.ID), 0)
    ) as OperatingZone,
    getTimetoFailure(
        class.ID
    ) as TagValue,
    class1.Name as LineName,
    details.Defintion - > > '$."Asset ID"' as definition
from
    asset_classification class
    left join
        asset_classification class1
    on  class1.ParentId = 2
    left join
        asset_details details
    on  details.Id in(
            select
                class.ID
        )
Where
    class.MCT_typeId = 5
and class.ParentId in(
        Select
            class1.ID
    )
group by
    class.Id
;
END
;
;

我有这个sql查询，在将sql文件导入phpmyadmin数据库时出错。
sql语法有错误；请查看与您的mysql服务器版本对应的手册，以获取“>”$“asset id”附近使用的正确语法
这里编辑的是mysql版本：