Python MySql make array of a Query

Question

I have a MySql query, everything works fine, but I want to make an array of each row to be used out of the query

Here is my code:

db = MySQLdb.connect(host="127.0.0.1", user="root", passwd="", db="seliso")

cursor = db.cursor()

cursor.execute("SELECT * FROM usuarios WHERE contador = " + "'" + userContador + "'")

results = cursor.fetchall()

for row in results:
    rfc = row[1]
    clave = row[2]

Example of I want to do:

db = MySQLdb.connect(host="127.0.0.1", user="root", passwd="", db="seliso")

cursor = db.cursor()

cursor.execute("SELECT * FROM usuarios WHERE contador = " + "'" + userContador + "'")

results = cursor.fetchall()

for row in results:
    rfc = row[1]
    clave = row[2]

$arrayRFC = ["rfc1", "rfc2", "rfc3"]
$arrayClave = ["clave1", "clave2", "clave3"]

How can this be acheived?

Thanks in advance.

mechanical_meat · Accepted Answer · 2016-07-14 03:22:59Z

1

You can get that with:

for i in zip(*results):
    print(list(i))

Further, you should not use string concatenation like that for reasons of SQL injection. Instead do:

cursor.execute("SELECT * FROM usuarios WHERE contador = %s",(userContador,))

Where %s is the parameter style per: http://mysql-python.sourceforge.net/MySQLdb.html

answered Jul 14, 2016 at 3:22

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

gustavo serna Over a year ago

Thank you so much, you are the best! :)

mechanical_meat Over a year ago

Cheers, mate. Happy coding to you :-)

gustavo serna Over a year ago

but how can I use it out of "for:"

gustavo serna Over a year ago

bro sorry, that isn't what I need. I need to use de "row" array out of "for:"

gustavo serna Over a year ago

mmm.. here is a php example: <?php $r=mysql_query("select * from clientes"); while($row=mysql_fetch_array($r)){ $cls[]=$row; } print(json_encode($cls)); mysql_close($con); ?>

|

Collectives™ on Stack Overflow

Python MySql make array of a Query

1 Answer 1

6 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Related