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" wrote: > 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 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 default mode would not output the column name. And it works for me: sqlite> create table sql_procs(name,sql); sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim')); sqlite> select sql from sql_procs where name = 'a'; select * from "mytable" ; sqlite> Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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 mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users