[DB-SIG] INTO sql command

Anand Patel anand123abc@hotmail.com
Wed, 07 Mar 2001 16:50:02 -0000


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:

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.