On Tuesday, January 8, 2019 at 11:29:04 PM UTC+8, Cédric Krier wrote:
> On 2019-01-08 06:55, [email protected] wrote:
> > 'The flavor of python-sql allows you to use almost any database using any
> > PEP 249 python library.'
> >
> > But I still don't know how to use it in mysql.
> >
> > conn = MySQLdb.Connect(unix_socket = config.mysql_sock,
> > user = config.mysql_user,
> > passwd = secret,
> > connect_timeout=10,
> > charset="utf8",
> > cursorclass = MySQLdb.cursors.DictCursor)
> > cursor = conn.cursor()
> >
> > user = Table('user')
> > select = user.select()
> > select.where = user.EnglishName=='testname'
> >
> > How to excute it ?
> > cursor.execute(select) ?
> > cursor.execute(tuple(select) ?
>
> You must run:
>
> cursor.execute(*select)
>
> The query object is iterable and return the query string follwed by the
> params.
>
> Or if you prefer you can also run:
>
> cursor.execute(str(select), select.params)
>
>
> --
> Cédric Krier - B2CK SPRL
> Email/Jabber: [email protected]
> Tel: +32 472 54 46 59
> Website: http://www.b2ck.com/
Thanks very much.It works.
In my MySQL ,I need to set SQL_MODE like:
sql> SET SESSION SQL_MODE=ANSI_QUOTES;
In python:
conn.set_sql_mode('ANSI_QUOTES')
--
You received this message because you are subscribed to the Google Groups
"python-sql" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
