-users@sqlite.org
Subject: Re: [sqlite] proper SQL DELETE syntax
On 7/14/05, Brass Tilde <[EMAIL PROTECTED]> wrote:
>>> 'Twere me, I'd do it like this:
>>>
>>> delete timeline
>>> from del_timelines
>>> wheretimeli
On 7/14/05, Brass Tilde <[EMAIL PROTECTED]> wrote:
>>> 'Twere me, I'd do it like this:
>>>
>>> delete timeline
>>> from del_timelines
>>> wheretimeline.name = del_timelines.name
>>> and timeline.lastchange <= del_timelines.last_change
>> I guess you mean... from timeline,del_tim
> >'Twere me, I'd do it like this:
> >
> >delete timeline
> >from del_timelines
> >wheretimeline.name = del_timelines.name
> >and timeline.lastchange <= del_timelines.last_change
> I guess you mean... from timeline,del_timeline ...
No, I meant what I wrote, exc
On 7/14/05, Downey, Shawn <[EMAIL PROTECTED]> wrote:
>>> DELETE from timeline where timeline.name=del_timelines.name and
>>> timeline.last_change<=del_timelines.last_change;
...
>> delete timeline
>> from del_timelines
>> wheretimeline.name = del_timelines.name
>> and timeline.lastch
>> DELETE from timeline where timeline.name=del_timelines.name and
>> timeline.last_change<=del_timelines.last_change;
>
>'Twere me, I'd do it like this:
>
>delete timeline
>from del_timelines
>wheretimeline.name = del_timelines.name
>and timeline.lastchange <= del_ti
> DELETE from timeline where timeline.name=del_timelines.name and
> timeline.last_change<=del_timelines.last_change;
'Twere me, I'd do it like this:
delete timeline
from del_timelines
wheretimeline.name = del_timelines.name
and timeline.lastchange <= del_timelines.l
--- "Downey, Shawn" <[EMAIL PROTECTED]> wrote:
> What is the correct SQL syntax for deleting records from
> a single table
> based on a where clause with multiple table references?
>
>
>
> For example:
>
>
>
> Sqlite> DELETE from timeline where
> timeline.name=del_timelines.name and
> ti
:57 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] proper SQL DELETE syntax
What is the correct SQL syntax for deleting records from a single table
based on a where clause with multiple table references?
For example:
Sqlite> DELETE from timeline where timeline.name=del_timelines.na
What is the correct SQL syntax for deleting records from a single table
based on a where clause with multiple table references?
For example:
Sqlite> DELETE from timeline where timeline.name=del_timelines.name and
timeline.last_change<=del_timelines.last_change;
SQL error: no such column
9 matches
Mail list logo
