Re: Question: Exporting a MySQL Table

Date view Thread view Subject view Author view Attachment view

From: Jukka-Pekka Vainio (jpvainio@eecs.Berkeley.EDU)
Date: Tue Sep 16 2003 - 11:46:14 PDT

You can use OUTFILE flag in your select statement

See

http://www.mysql.com/doc/en/SELECT.html

Preetam Mukherjee wrote:

> Would anyone happen to know of any sql queries that would export a
> table in MySQL to a flat text, or other similar format, file?
>
> Failing that, what's a possible alternative way to retrieve
> information off a MySQL database, periodically?
>
> Thanks,
> preetam
>
> 

-- 
Jukka-Pekka Vainio   Cellular (510) 334-1054
Room 481
http://www-bsac.eecs.berkeley.edu/~jpvainio
University of California
Berkeley Sensor & Actuator Center
497 Cory Hall
Berkeley, CA 94720-1770
-----------------------------------------------------------------------
The following was automatically added to this message by the list server:
Webnet information is available at <URL:http://webnet.berkeley.edu/>.
Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.5 : Tue Sep 16 2003 - 11:46:56 PDT