List:General Discussion« Previous MessageNext Message »
From:Dino Date:June 15 1999 5:22pm
Subject:Re: Exporting
View as plain text  

> Hey guys does anyone know how to export a query from a database to an
> excel file or some kind of etxt format??

Hi, Rog!

You must use
"select * from sometable  into outfile "name_of_txt_file"

The default options will create a file with ";" separeted records which
would be easy to import into excel;

I use a friendly programm called myAdmin (you can get it at
http://www.mysql.net/Downloads/Win32/myAdmin1.0.1.0.zip)
and you can make a query and use the right click to export it.

Dino

Attachment: [application/x-pkcs7-signature] smime.p7s
Attachment: [application/x-pkcs7-signature] smime.p7s
Thread
DEFAULT value as DATEPinkeshP15 Jun
  • RE: DEFAULT value as DATEJay Miller15 Jun
  • ExportingRoger Smith15 Jun
    • Re: ExportingBen Kirkpatrick15 Jun
    • Re: ExportingDino15 Jun