On 10 Jul 2014 at 14:17, Mark Lawrence wrote:
> On Thu Jul 10, 2014 at 01:52:00PM +0100, Tim Streater wrote:
>>
>> What I'm actually doing is moving/copying a row from one database to
>> another, where the two databases have identical schemas.
>> ...
>>
>> So there are two copy steps. What I'd li
On Thu Jul 10, 2014 at 01:52:00PM +0100, Tim Streater wrote:
>
> What I'm actually doing is moving/copying a row from one database to
> another, where the two databases have identical schemas.
> ...
>
> So there are two copy steps. What I'd like to do is:
>
> ...
>
> but unfortunately there cou
On 10 Jul 2014 at 12:45, Simon Slavin wrote:
> On 10 Jul 2014, at 11:47am, Clemens Ladisch wrote:
>
>> This is indeed misleading. The result set actually has columns and
>> column names even when there are now rows in it, so this is guaranteed
>> to work even for empty result sets.
Thanks. I'l
On 10 Jul 2014, at 11:47am, Clemens Ladisch wrote:
> This is indeed misleading. The result set actually has columns and
> column names even when there are now rows in it, so this is guaranteed
> to work even for empty result sets.
However, all is not as you might expect:
SQLite version 3.7.13
Tim Streater wrote:
> I have a handy SELECT available, but I don't want to actually insert
> a row at that time. Testing with the shell, the following appears to
> work:
>
> attach database ':memory:' as mem;
> create table mem.messages as select * from main.messages limit 0;
>
> and I get a ne
On 10 Jul 2014 at 11:20, Dan Kennedy wrote:
> On 07/10/2014 04:45 PM, Tim Streater wrote:
>> I have just noticed this syntax which will simplify some table creation for
>> me. However in some instances where I want to use it, I have a handy SELECT
>> available, but I don't want to actually insert
On 07/10/2014 04:45 PM, Tim Streater wrote:
I have just noticed this syntax which will simplify some table creation for me.
However in some instances where I want to use it, I have a handy SELECT
available, but I don't want to actually insert a row at that time. Testing with
the shell, the fol
I have just noticed this syntax which will simplify some table creation for me.
However in some instances where I want to use it, I have a handy SELECT
available, but I don't want to actually insert a row at that time. Testing with
the shell, the following appears to work:
attach database ':m
8 matches
Mail list logo