Jay Sprenkle uttered:
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote:
You can't use aggregate functions in WHERE clauses. Also, you can't use a
select as the value in an insert. You can insert from the results of an
insert.
uh...It seems to work:
The OP was trying to use a SELECT
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote:
You can't use aggregate functions in WHERE clauses. Also, you can't use a
select as the value in an insert. You can insert from the results of an
insert.
uh...It seems to work:
SQLite version 3.0.8
Enter ".help" for instructions
sqlite>
Keiichi McGuire uttered:
I'm a bit stuck on this one problem
I have this simple table that has two fields: id and value.
What I want to do is to get the largest id (the last entry) and then add an
arbitrary number to the value that's in the same entry as that one, and put
the result in the
I'm a bit stuck on this one problem
I have this simple table that has two fields: id and value.
What I want to do is to get the largest id (the last entry) and then add an
arbitrary number to the value that's in the same entry as that one, and put
the result in the next entry.
to make it sound
4 matches
Mail list logo