Код: Выделить всё
*CLI> core show application MYSQL
*CLI>
-= Info about application 'MYSQL' =-
[Synopsis]
Do several mySQLy things
[Description]
MYSQL(): Do several mySQLy things
Syntax:
MYSQL(Set timeout <num>)
Set the connection timeout, in seconds.
MYSQL(Connect connid dhhost dbuser dbpass dbname)
Connects to a database. Arguments contain standard MySQL parameters
passed to function mysql_real_connect. Connection identifer returned
in ${connid}
MYSQL(Query resultid ${connid} query-string)
Executes standard MySQL query contained in query-string using established
connection identified by ${connid}. Result of query is stored in ${resultid}.
MYSQL(Nextresult resultid ${connid}
If last query returned more than one result set, it stores the next
result set in ${resultid}. It's useful with stored procedures
MYSQL(Fetch fetchid ${resultid} var1 var2 ... varN)
Fetches a single row from a result set contained in ${result_identifier}.
Assigns returned fields to ${var1} ... ${varn}. ${fetchid} is set TRUE
if additional rows exist in result set.
MYSQL(Clear ${resultid})
Frees memory and datastructures associated with result set.
MYSQL(Disconnect ${connid})
Disconnects from named connection to MySQL.
On exit, always returns 0. Sets MYSQL_STATUS to 0 on success and -1 on error. 
