asterisk.ru

Код: Выделить всё

*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.