Re: [exim] Running a SQL Insert command

Pàgina inicial
Delete this message
Reply to this message
Autor: Peter Velan
Data:  
A: exim-users @ exim. org
Assumpte: Re: [exim] Running a SQL Insert command
am 07.04.05 15:46 schrieb Michael da Silva Pereira:

> I tried double" and single' nothing makes a difference.
>
>>> warn set acl_m9 = ${lookup mysql {INSERT INTO message_log \
>>> (msgid, from, to, host, ctime) \


I'm using backticks (ok, theres a saying in the mysql comunity about bad
style doing this) because I don't want to study the manual about
allowable column names any time I'm naming a column (or database, or
...). I would write above line as:

(`msgid`, `from`, `to`, `host`, `ctime`) \

>>> values \
>>> ("msgid", \
>>> "from", \
>>> "to", \
>>> "host" \
>>> ,"ctime")}}


Peter