On Tue, 15 Feb 2011 03:30:23 -0800 (PST), venkat easwar
<[email protected]> wrote:
>Oh... Thanks Kennedy. Between any options on run time to enable the feature?
No, it's a compile-time option, compiling without
SQLITE_ENABLE_UPDATE_DELETE_LIMIT makes SQLite a bit lighter.
Without that feature, if you want to update one row, use it's unique
key in a WHERE clause. In your schema, it would make sense to create
the table like this:
create table check_update(
a INTEGER PRIMARY KEY,
b TEXT,
c INTEGER
);
The INSERTs will stay the same, and the update statement becomes
something like:
UPDATE check_update
SET b='venkat n'
WHERE a = (
SELECT min(a)
FROM check_update
WHERE b='venkat'
);
Hpoe this helps.
>________________________________
>From: Dan Kennedy <[email protected]>
>To: [email protected]
>Sent: Tue, February 15, 2011 4:48:24 PM
>Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR
>
>On 02/15/2011 06:04 PM, venkat easwar wrote:
>> Forgot to mention what error I am getting.
>>
>> near "order": syntax error
>> near "limit": syntax error - if i remove the order by clause
>
>See under the "Optional LIMIT and ORDER BY Clauses" heading
>on this page:
>
> http://www.sqlite.org/lang_update.html
>
>You need to build SQLite with SQLITE_ENABLE_UPDATE_DELETE_LIMIT
>defined.
>
> http://www.sqlite.org/compile.html#enable_update_delete_limit
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
