String substitution VS proper mysql escaping

[Νίκος]

On 28 Αύγ, 22:35, MRAB <pyt... at mrabarnett.plus.com> wrote:

> """When there's more than one value you provide a tuple. It's makes sense
> from the point of view of consistency that you also provide a tuple when
> there's only one value."""

Can you write something that make use of more than one value?


Perhaps you mena somethign like?

cursor.execute( '''SELECT hits FROM counters WHERE page = %s and date
= %s and host = %s''' , (page,) )

Is this what you mean?

All those special format strign identifiers will grab their values out
of the tuple?