[Asterisk-Users] writing to MYSQL database

[Matthew Boehm]

Brett, Gary wrote:
> Hi there
>
> I have been successfully using the asterisk command "MYSQL" to read
> information from a MySql database, but was wondering if there was any
> way of WRITING data (ie user input data) to the database ???, looking
> through the parameters of the MYSQL command it seems as though this
> function isn't available....is there another application for this???
>
>
> Cheers

The MYSQL command you speak of should support any query supported by MySQL.

 exten => _9.,1,MYSQL(Connect connid 210.55.55.55 asterisk asterisk
asterisk)
 exten => _9.,n,MYSQL(Query resultid ${connid} INSERT INTO testtable VALUES
('himom','hidad','hisister'))
 exten => _9.,n,MYSQL(Disconnect ${connid})

(the above is untested)

-Matthew