import _mysql as mysql
db=mysql.connect('localhost','username','password','database')
db.query("""select * from news""")
result = db.store_result()
print result.num_rows()#two records
#how to loop? without cursor
print result.fetch_row()
views:
95answers:
3
+2
A:
You should not be importing _mysql
. Symbols that start with a single underscore are for private use. Import MySQLdb
and read PEP 249 for its use.
Ignacio Vazquez-Abrams
2010-09-03 06:58:06
+1
A:
You can try this:
while True:
record = result.fetch_row()
if not record: break
print record
I second @Ignacio's note of caution against using _mysql
. Switch to import MySQLdb
.
Manoj Govindan
2010-09-03 07:02:24
A:
I'm not sure how you plan on using the loop, but you could do something like this:
while x < result.num_rows():
#do something for each row
X += 1
Nick011
2010-09-03 07:07:01