Unloading data from script in Mysql 1

[carlg]

In Inofmrix database, I would do the following in my script

dbaccess custdb << !
unload to myfile.unl
select * from mytable
!


and the myfile.unl would have the data in a pipe delimited format.


How do I do this with mysql??

Thanks for the info.

Carl

 

[TonyGroves]

You could use something like:
[tt]
SELECT *
INTO OUTFILE '/tmp/myfile.unl' FIELDS TERMINATED BY '|'
FROM mytable
[/tt]
There are many other file-format options; these are explained in the manual.

 

[carlg]

Thanks

That works perfectly!!!!