BareFeet wrote:
>
>
>>> How can I get just the column headers without all the result rows?
>>>
>> Turn headers on, then perform a search which gives no results.
>>
>
> Unfortunately, the sqlite3 command line tool does not show the headers
> when there are no result rows.
>
>
Yo
On 5 Jul 2009, at 2:35am, BareFeet wrote:
> Hi Simon,
Just a reminder that you're posting to a list, not to me personally.
>> What are you trying to do ? Find all the columns in a TABLE or find
>> all the columns in an arbitrary SELECT ? If it's the former use
>> PRAGMA table_info for the ta
Hi Simon,
>> In any case, it's not possible to convert an ad hoc query (ie not
>> known beforehand) into one that returns no rows.
>
> Sure it is. Just add 'WHERE 1=2' to it if there's no WHERE clause,
> or 'AND 1=2' if there is.
Increasing potential complexity of the "ad hoc" SQL command wo
Hi Simon,
How can I get just the column headers without all the result rows?
>>>
>>> Turn headers on, then perform a search which gives no results.
>>
>> Unfortunately, the sqlite3 command line tool does not show the
>> headers
>> when there are no result rows. In any case, it's nit possibl
On 5 Jul 2009, at 12:31am, BareFeet wrote:
> Hi Simon,
>
>>> How can I get just the column headers without all the result rows?
>>
>> Turn headers on, then perform a search which gives no results.
>
> Unfortunately, the sqlite3 command line tool does not show the headers
> when there are no resul
2009/7/5 BareFeet :
>>>
> Hi Simon,
>
>>> How can I get just the column headers without all the result rows?
>>
>> Turn headers on, then perform a search which gives no results.
>
> Unfortunately, the sqlite3 command line tool does not show the headers
> when there are no result rows. In any case,
>>
Hi Simon,
>> How can I get just the column headers without all the result rows?
>
> Turn headers on, then perform a search which gives no results.
Unfortunately, the sqlite3 command line tool does not show the headers
when there are no result rows. In any case, it's nit possible to
convert
On 29 Jun 2009, at 1:05pm, BareFeet wrote:
> How can I get just the column headers without all the result rows?
Turn headers on, then perform a search which gives no results.
It's difficult in the command-line tool, but easy using function calls
since there's a function call specially intende
Thanks Jens and John for your replies.
Yes, I am familiar with the "headers on" option. Sorry, I should have
mentioned.
However, that prepends the headers to the result rows. It would also
be ambiguous if a column header contains a pipe or quote or newline
(which is unlikely but possible).
On 29/06/2009 2:57 PM, BareFeet wrote:
> Hi,
>
> Is there any way in the command line to get the columns in a query
> result?
>
> For example, given an ad-hoc SQL command, such as:
>
> begin;
> insert into MyTableOrView select * from SomeSource;
> select * from MyTableOrView join SomeOtherTabl
Am 29.06.2009 um 06:57 schrieb BareFeet:
> Hi,
>
> Is there any way in the command line to get the columns in a query
> result?
>
> For example, given an ad-hoc SQL command, such as:
>
> begin;
> insert into MyTableOrView select * from SomeSource;
> select * from MyTableOrView join SomeOtherTable
Hi,
Is there any way in the command line to get the columns in a query
result?
For example, given an ad-hoc SQL command, such as:
begin;
insert into MyTableOrView select * from SomeSource;
select * from MyTableOrView join SomeOtherTableOrView where condition;
end;
how can I get the column hea
12 matches
Mail list logo