Re: [sqlite] shell edit quoting

I think you're in "csv mode": sqlite> select sql from sql_procs where name = 'a'; select * from "mytable" ; sqlite> .header on sqlite> .mode csv sqlite> select sql from sql_procs where name = 'a'; sql "select * from ""mytable"" ; " On 5/13/18, 7:04 PM, "sqlite-users on behalf of David Burgess"

Re: [sqlite] shell edit quoting

> And it works for me: I'm pleased for you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] shell edit quoting

David Burgess wrote: >> Where do the quotes around the value come from? > > I typed them. Simgle set of double quotes I meant the quotes around the entire value returned by the SELECT. >> Are you using the standard command-line shell, and which output mode? > > yes and the default mode The

Re: [sqlite] shell edit quoting

> Where do the quotes around the value come from? I typed them. Simgle set of double quotes > Are you using the standard command-line shell, and which output mode? yes and the default mode ___ sqlite-users mailing list

[sqlite] shell edit quoting.

sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim')); then in the editor I enter one line: select * from "mytable" ; sqlite> select sql from sql_procs where name = 'a'; sql "select * from ""mytable""; " edit() seems to give 2 quotes for each one entered in the editor.

Re: [sqlite] shell edit quoting

> sqlite> select sql from sql_procs where name = 'a'; > sql > "select * from ""mytable""; > " Where do the quotes around the value come from? Are you using the standard command-line shell, and which output mode? Regards, Clemens ___ sqlite-users

[sqlite] shell edit quoting

sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim')); then in the editor I enter one line: select * from "mytable" ; sqlite> select sql from sql_procs where name = 'a'; sql "select * from ""mytable""; " edit() seems to give 2 quotes for each one entered in the editor.