Re: [sqlite] deleting a single row

2007-02-20 Thread Jim Crafton
Excellent! I didn't realize that the "oid" existed! This is perfect. Thanks for this! Not directly. But every row has an implicit primary key that you can refer to using (amongst other names) "oid". You can use a SELECT to locate a single oid value and then use the oid to delete a single row. i.

Re: [sqlite] deleting a single row

2007-02-20 Thread Jim Crafton
:) On 2/20/07, P Kishor <[EMAIL PROTECTED]> wrote: On 2/20/07, P Kishor <[EMAIL PROTECTED]> wrote: > On 2/19/07, Jim Crafton <[EMAIL PROTECTED]> wrote: > > If I have a simple table without an index column, and have multiple > > rows with the same data, is it possible to *only* delete one row? In

Re: [sqlite] deleting a single row

2007-02-19 Thread P Kishor
On 2/20/07, P Kishor <[EMAIL PROTECTED]> wrote: On 2/19/07, Jim Crafton <[EMAIL PROTECTED]> wrote: > If I have a simple table without an index column, and have multiple > rows with the same data, is it possible to *only* delete one row? In > other words, is there anything like the LIMIT syntax th

Re: [sqlite] deleting a single row

2007-02-19 Thread P Kishor
On 2/19/07, Jim Crafton <[EMAIL PROTECTED]> wrote: If I have a simple table without an index column, and have multiple rows with the same data, is it possible to *only* delete one row? In other words, is there anything like the LIMIT syntax that's found in the SELECT command for DELETEs? you

Re: [sqlite] deleting a single row

2007-02-19 Thread Dan Kennedy
On Tue, 2007-02-20 at 00:29 -0500, Jim Crafton wrote: > If I have a simple table without an index column, and have multiple > rows with the same data, is it possible to *only* delete one row? In > other words, is there anything like the LIMIT syntax that's found in > the SELECT command for DELETEs?

[sqlite] deleting a single row

2007-02-19 Thread Jim Crafton
If I have a simple table without an index column, and have multiple rows with the same data, is it possible to *only* delete one row? In other words, is there anything like the LIMIT syntax that's found in the SELECT command for DELETEs? Thanks, Jim -