[DB-SIG] INTO sql command
Anand Patel
anand123abc@hotmail.com
Wed, 07 Mar 2001 16:50:02 -0000
Hi
I don't know if anyone can help, but basically I am using python to connect
to a database (MySQL). Within the database I have a table and wanted to use
the INTO command to read info off the table and store it in a list one at a
time. However, MySQL doesn't like the INTO command.
I think I have got around this by:
-cursor.execute('select url from web_table where web_tuple_num = 1')
-url1 = cursor.fetchall()
however, when I type:
-url1[0]
to access the first element, I get : ('www.breakbeat.co.uk',)
and was wondering if there was someway of getting: www.breakbeat.co.uk
without brackets and inverted commas.
Any help would be useful
Many thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.