`paraworld.MQL.query`

Contents

Description

执行传入的MQL语句，并将结果返回

Parameters

Required	Name	Type	Description
required	query	string	规范的MQL语句
optional	appKey	string	应用程序Key
optional	sessionKey	string	用户凭证

Return XML

（1）若是select语句，则返回类似于下面的XML格式：

<msg xmlns="">
        <users>
                <param index="1">
                        <uid type="string">f5f3de7a-05b2-42a0-bd78-415a939020c2</uid>
                        <uname type="string">clayman</uname>
                        <createDate type="string">2008-5-5 7:44:11</createDate>
                </param>
                <param index="2">
                        <uid type="string">6ea770c6-92b2-4b2b-86da-6f574641ec11</uid>
                        <uname type="string">andy</uname>
                        <createDate type="string">2008-5-5 7:36:12</createDate>
                </param>
                <param index="3">
                        <uid type="string">8ec11316-bc2e-491d-8f18-667501687e69</uid>
                        <uname type="string">ParaEngine</uname>
                        <createDate type="string">2008-5-5 7:36:05</createDate>
                </param>
        </users>
        <query type="string">
                select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1' order by createdate desc
        </query>
</msg>

（2）若是update、delete、insert语句，则返回类似于下面的XML：

<msg>
        <isSuccess>true</isSuccess>
        <query type="string">
                update users set email = 'aaa@gmail.com' where uid = 'f5f3de7a-05b2-42a0-bd78-415a939020c2'
        </query>
</msg>

（3）若发生异常，则返回类似于下面的XML：

<msg>
        <errorCode>494</errorCode>
        <query type="string">
                select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1'
        </query>
</msg>

Tables

users
fields

Name	Type	Description
uid	GUID	用户的唯一标识符
uname	string	用户名
createDate	datetime	注册时间
lastActivityDate	datetime	最后活跃时间
email	string	用户的电子邮箱地址