maria-discuss team mailing list archive

[Brian Evans <grknight@xxxxxxxxxxxxxx>]

On 5/19/2010 1:42 PM, Cool Guy wrote:
> Oh yeah, I noticed CSV. Is pipe delimited possible too? If yes, this
> would solve the problem.

Sure, just change the comma to a pipe if that's what you desire.  Again,
it was only an example and any literal string is possible with CONCAT.
The format is up to *your* imagination and preparation. Just don't
forget to escape any double quotes as the shell might interpret that as
the end of the command if you don't.

Brian
>
> On Wed, May 19, 2010 at 1:38 PM, Brian Evans <grknight@xxxxxxxxxxxxxx
> <mailto:grknight@xxxxxxxxxxxxxx>> wrote:
>
>     On 5/19/2010 1:32 PM, Cool Guy wrote:
>>     Yep, but the only problem is the inability to dump it as pipe or
>>     CSV format - in other words, we don't have any flexibility at all
>>     in the way of formatting the out file. 
>>
>>     Thanks for the continued super quick replies!
>
>     My example dumps to CSV if you looked at it closely.
>     The CONCAT does the format and the -Nsr gets rid of the table-like
>     structure.
>
>     Brian
>
>>
>>     On Wed, May 19, 2010 at 1:27 PM, Brian Evans
>>     <grknight@xxxxxxxxxxxxxx <mailto:grknight@xxxxxxxxxxxxxx>> wrote:
>>
>>         On 5/19/2010 1:12 PM, Cool Guy wrote:
>>>         mysqldump is more like a backup tool and is used to dump the
>>>         whole table/database rather than select records ...
>>>
>>>         The workaround we came up with is dump the data to a temp
>>>         table and then use a python program to convert and dump the
>>>         table in CSV format. Though it works, I feel it is redundant
>>>         and not so efficient way of doing things.
>>
>>         On second thought, you CAN use the mysql -e IF you do this
>>         (as an example):
>>
>>         mysql -u root -p -Nsr -e "SELECT
>>         CONCAT('\"',FirstName,'\",\"',LastName,'\"') from db.users"
>>
>>         Change to suit.
>>
>>
>>>
>>>         On Wed, May 19, 2010 at 1:04 PM, Brian Evans
>>>         <grknight@xxxxxxxxxxxxxx <mailto:grknight@xxxxxxxxxxxxxx>>
>>>         wrote:
>>>
>>>             On 5/19/2010 12:58 PM, Cool Guy wrote:
>>>             > Sorry for the confusion. We can dump the file to the
>>>             server where the
>>>             > database is hosted but this problem revolves around 2
>>>             different
>>>             > servers - 1. Client, 2. Database.
>>>             >
>>>             > So we want to dump the output to the client and MySQL
>>>             has no such
>>>             > implementation. I explored the -e option and
>>>             specifying the server
>>>             > name but it outputs only .txt file and there is no way
>>>             of specifying
>>>             > CSV or pipe-delimited file.
>>>             >
>>>             > Thank you...
>>>
>>>             This calls for mysqldump then.
>>>             http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
>>>
>>>             Other 3rd party clients can do this too.
>>>
>