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 <[email protected] > <mailto:[email protected]>> 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 >> <[email protected] <mailto:[email protected]>> 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 >>> <[email protected] <mailto:[email protected]>> >>> 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. >>> >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
