[sqlite] .DUMP output compatibility
On Fri, 6 May 2016 01:56:47 +0300, "Tony Papadimitriou" wrote: > Windows! There's gawk for windows, for this purpose almost the same as sed. And apart form cygwin, there is a unch of unix utilities under the name of UnxUtils. See https://en.wikipedia.org/wiki/UnxUtils and https://sourceforge.net/projects/unxutils/ -- Regards, Kees Nuyt >-Original Message- >From: Richard Hipp >Sent: Friday, May 06, 2016 1:55 AM >To: SQLite mailing list >Subject: Re: [sqlite] .DUMP output compatibility > >On 5/5/16, Tony Papadimitriou wrote: >> Is it possible for .DUMP to produce table/field names quoted with ` >> (backquote) instead of ? (double quote) for compatibility with MySQL? >> Or is this already adjustable by some setting I missed? > >Pipe the output through sed (https://en.wikipedia.org/wiki/Sed)
[sqlite] .DUMP output compatibility
Windows! -Original Message- From: Richard Hipp Sent: Friday, May 06, 2016 1:55 AM To: SQLite mailing list Subject: Re: [sqlite] .DUMP output compatibility On 5/5/16, Tony Papadimitriou wrote: > Is it possible for .DUMP to produce table/field names quoted with ` > (backquote) instead of ? (double quote) for compatibility with MySQL? > Or is this already adjustable by some setting I missed? Pipe the output through sed (https://en.wikipedia.org/wiki/Sed) -- D. Richard Hipp drh at sqlite.org ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] .DUMP output compatibility
Is it possible for .DUMP to produce table/field names quoted with ` (backquote) instead of ? (double quote) for compatibility with MySQL? Or is this already adjustable by some setting I missed? Thank you.
[sqlite] .DUMP output compatibility
On 5/5/16, Tony Papadimitriou wrote: > Is it possible for .DUMP to produce table/field names quoted with ` > (backquote) instead of ? (double quote) for compatibility with MySQL? > Or is this already adjustable by some setting I missed? Pipe the output through sed (https://en.wikipedia.org/wiki/Sed) -- D. Richard Hipp drh at sqlite.org
[sqlite] .DUMP output compatibility
On May 5, 2016, at 4:56 PM, Tony Papadimitriou wrote: > > Windows! So install Cygwin. There may be more to it than the quoting style. I?ve used the following script for moving data the other direction (MySQL to SQLite): https://gist.github.com/esperlu/943776 You might have to create the inverse of some of those transformations to get MySQL to accept the data.