开发者

meaning of this sql statement

开发者 https://www.devze.com 2023-03-02 19:44 出处：网络

I just found a code like this in my new project. and i have no idea wht it does. $q = \"SELECT getnewmsg(\" . $_GET[\'messgae\'] . \" result)\";

相关专题：php

I just found a code like this in my new project. and i have no idea wht it does.

$q = "SELECT getnewmsg(" . $_GET['messgae'] . " result)";

i searched for getnewmsg in whole file system and i did not get it. Can yo开发者_JS百科u please let me know does it actually mean. i have never seen such sql statement.

If you want to know more about the procedure (in case it is a procedure), you may send the following query:

SHOW PROCEDURE STATUS LIKE 'getnewmsg';

For more information, see the MySQL manual for SHOW PROCEDURE STATUS.

"getnewmsg" is not found in a search of the Mysql site, so it is probably a stored procedure that has been added to your particular database. We have no way of telling what it does.

looks like stored function http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html