Geert JM Vanderkelen

MySQL Connector/Python 1.0.9 available for download

MySQL Connector/Python 1.0.9 available for download

Today we released MySQL Connector/Python v1.0.9. Release notes can be found in the MySQL Developver Zone.

Connector/Python v1.0.9 contains some important fixes, especially for the Windows platform. It also comes with a new connection argument called force_ipv6, and can be used to force IPv6 when an address resolves to both IPv4 and v6. Also, RPM packages have been made available in addition to the TAR/ZIP and MSI packages.

Please use the MySQL Bugs website to report any problem.

Some useful links:

Enjoy!

7 thoughts on “MySQL Connector/Python 1.0.9 available for download

  1. zhang

    Hi Geert,

    mysql-connector-python dose not support last_insert_id yet, right? I could not find any function about it in refman.

    Thanks,

  2. Geert Vanderkelen Post author

    @zhang
    It is.. indeed not in the documentation. That’s something we need to fix.
    However, it is part of PEP-249, and it is a cursor property called ‘lastrowid’

    Example:

    >>> import mysql.connector
    >>> cnx = mysql.connector.connect(…….)
    >>> cur = cnx.cursor()
    >>> cur.execute(“INSERT INTO t1 (c1) VALUES (‘ham’)”)
    >>> cur.lastrowid
    1

  3. zhang

    ya..it is cool

    this afternoon I also tried lastrowid like MySQLdb. It is excited to me that *SHE* is already there :P
    rowcount is also available even though it is yet to document.

    thanks,

  4. zhang

    sorry…many questions

    I am puzzled about with_rows. “This read-only property will return True when the result of the executed operation provides rows.” — from RefMan But, as follow is :

    query = (“select name from test_innodb where age > 100″) ## empty rows

    for result in cur.execute(query):
    if result.with_rows:
    print (“Statement: {0}”.format(result.statement))

    I found result.with_rows was always True if query is just SELECT statement whose result is empty or not.

    Thanks,

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 83 = 88

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>