Title: RE: sqlstring -- a library to build a SELECT statement

Tim Roberts wrote:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> >
> >An Example:
> >
> >>>> import sqlstring
> >>>> model = sqlstring.TableFactory()
> >>>> print model.person
> >SELECT
> >person.*
> >FROM
> >[person] person
>
> The [bracket] syntax is unique to Microsoft.
> Everyone else, including Microsoft SQL Server,
> uses "double quotes" to protect special characters
> in identifiers.

Except MySQL (at least 4.1), which uses backticks.
http://dev.mysql.com/doc/refman/4.1/en/legal-names.html


Robert Brewer
System Architect
Amor Ministries
[EMAIL PROTECTED]

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to