Re: Using MySQLdb to select into the local file

2008-05-23 Thread Nikhil
John Nagle wrote: Nikhil wrote: I am using the MySQLdb python module. I have a table named 'testing' with few columns, under the 'test' database, what is hosted on a remote mysql server. I want to run the following query to get a comma-separated information from the table LOCK TABLES foo

Re: Using MySQLdb to select into the local file

2008-05-22 Thread John Nagle
Nikhil wrote: I am using the MySQLdb python module. I have a table named 'testing' with few columns, under the 'test' database, what is hosted on a remote mysql server. I want to run the following query to get a comma-separated information from the table LOCK TABLES foo READ; SELECT a,b,a+

Using MySQLdb to select into the local file

2008-05-22 Thread Nikhil
I am using the MySQLdb python module. I have a table named 'testing' with few columns, under the 'test' database, what is hosted on a remote mysql server. I want to run the following query to get a comma-seperated information from the table LOCK TABLES foo READ; SELECT a,b,a+b INTO OUTFILE