It seems to me that this should be invalid as COUNT(id) does not refer to a
valid field in the subquery's column list. I would vote for throwing an
error as it seems that wrong. Since its been over six years since I wrote
that query, I don't know what I was thinking at the time.
Sent from my iPhon
On 2013.06.13 7:22 PM, Yongil Jang wrote:
Thank you, Richard and James.
2013/6/14 James K. Lowden
Why not simply
SELECT f.name, count(e.food_id) as 'episodes'
FROM foods as f
OUTER
JOINfoods_episodes as e
ON f.id = e.food_id
GROUP BY f.name
ORDER BY episodes DESC LIMIT 10;
Thank you, Richard and James.
2013/6/14 James K. Lowden
>
>
> Why not simply
>
> SELECT f.name, count(e.food_id) as 'episodes'
> FROM foods as f
> OUTER
> JOINfoods_episodes as e
> ON f.id = e.food_id
> GROUP BY f.name
> ORDER BY episodes DESC LIMIT 10;
>
>
In my opinion,
That ex
On Thu, 13 Jun 2013 08:13:29 -0400
Richard Hipp wrote:
> SELECT
> name,
> (SELECT COUNT(food_id) FROM foods_episodes WHERE food_id=f.id) count
> FROM
> foods f
> ORDER BY count DESC LIMIT 10;
...
> SELECT
> name,
> (SELECT COUNT(*) FROM foods_episodes WHERE food_id=f.id) count
> FROM
>
On Thu, Jun 13, 2013 at 12:24 AM, Yongil Jang wrote:
> Dear all,
>
> Following select query returns different result data between v3.7.11 and
> v3.7.13~.
>
> CREATE TABLE foods(
> id integer primary key,
> type_id integer,
> name text );
> CREATE TABLE foods_episodes(
> food_id integer,
>
Thank you, Igor. :)
2013/6/13 Igor Tandetnik
> On 6/13/2013 12:24 AM, Yongil Jang wrote:
>
>> SELECT
>>name,
>>(SELECT COUNT(id) FROM foods_episodes WHERE food_id=f.id) count
>> FROM
>>foods f
>> ORDER BY count DESC LIMIT 10;
>>
>>
>> Result from v3.7.6 and v3.7.11.
>>
>> Hot Dog|5
On 6/13/2013 12:24 AM, Yongil Jang wrote:
SELECT
name,
(SELECT COUNT(id) FROM foods_episodes WHERE food_id=f.id) count
FROM
foods f
ORDER BY count DESC LIMIT 10;
Result from v3.7.6 and v3.7.11.
Hot Dog|5
Kasha|4
Ketchup|4
..
Result from v3.7.13 and v3.7.17.
Wax Beans (Generic b
Dear all,
Following select query returns different result data between v3.7.11 and
v3.7.13~.
CREATE TABLE foods(
id integer primary key,
type_id integer,
name text );
CREATE TABLE foods_episodes(
food_id integer,
episode_id integer );
[Insert some data]
SELECT
name,
(SELECT COUNT(
On 30 Apr 2010, at 6:33pm, Hal Faulkner wrote:
> I want to program using Cocoa/Objective-C with Mac OSX 10.6 Xcode & Interface
> Builder to create and use persistent SQLite3 database.
>
> I have failed in my search for code examples or tutorials which show the use
> of objects to use SQLite.
On Fri, Apr 30, 2010 at 12:33 PM, Hal Faulkner wrote:
> I want to program using Cocoa/Objective-C with Mac OSX 10.6 Xcode & Interface
> Builder to create and use persistent SQLite3 database.
>
> I have failed in my search for code examples or tutorials which show the use
> of objects to use SQLi
I want to program using Cocoa/Objective-C with Mac OSX 10.6 Xcode & Interface
Builder to create and use persistent SQLite3 database.
I have failed in my search for code examples or tutorials which show the use of
objects to use SQLite. I have run out of web search word combinations.
All I ha
Hi,
I got the book, "The definitive guide to SQLite". Wondering if anyone has same
issue or know the answer.
Following is the error when compiling the example CAPI example code
[tjy...@ibm examples]$ ls
capi commonfoods.sql perlruby tcl
capi_ext foods.db java py
.
> It is a miracle any computer books are any good.
I have several with indices that are highly usable. The topics include
wxPython, SQL, PostgreSQL, and a bunch of others. In my experience, the
SQLite book is an unfortunate exception.
Rich
--
Richard B. Shepard, Ph.D. | Integ
> First, the index is completely unusable.
I'll second that, worst index that I have ever tried to use.
On Wed, Jun 18, 2008 at 11:05 PM, Roger Binns <[EMAIL PROTECTED]> wrote:
> Stefan Arentz wrote:
> > First, the index is completely unusable.
>
> From the few authors I have spoken to, they do
Stefan Arentz wrote:
> First, the index is completely unusable.
>From the few authors I have spoken to, they don't make the index
themselves. The publisher does it using someone else and you end up
with junk, and they bill the author for it!
It is a miracle any computer books are any good. I su
I loved the book. It had a very good introduction to SQL and even as an
experienced SQL developer I learned a few things from that, the coverage of
SQLite was a wonderful introduction, and it covered some advanced topics
well. SQLite changes so much that a lot of things don't apply any more, so
I
On Wed, 18 Jun 2008, Stefan Arentz wrote:
> Sorry if this is a little offtopic but I am curious what other people thing.
Stefan,
I think that Mike did an outstanding job with the book, and the appalling
index is not his fault. I wrote to the publisher about it but never received
a reply.
On Jun 18, 2008, at 8:01 AM, Stefan Arentz wrote:
> Sorry if this is a little offtopic but I am curious what other
> people thing.
>
> Is it just me, or is the APress book 'The definitive guide to SQLIte'
> not very high quality?
>
> First, the index is completely unusable. The index is grouped
In general, I have been very happy with it. It is a great introduction
and provides lots of examples. I think of it as more of a tutorial than
a reference manual. The SQLite web site is a better reference manual,
but lacks the examples and sample code that the book offers. Once you
get the basi
Sorry if this is a little offtopic but I am curious what other people thing.
Is it just me, or is the APress book 'The definitive guide to SQLIte'
not very high quality?
First, the index is completely unusable. The index is grouped by
subject, so if you want to for example lookup where the book t
I have purchased two books on SQLite.
"The Definitive Guide to SQLite" by Micheal Owens covers version 3.
"SQLite" by Chris Newman covers version 2, but most is applicable to version
3.
I have found both to be helpful, and would recommend buying either, or both.
However, IMO th
Hello.. Please I need to know if is there a Good book about SQLite i want to
learn it, i want to know how to optimize and how it works
Thanks to all
On Feb 11, 2006, at 17:59, Clint Bailey wrote:
Hi,
Is there any know book in print for sqlite that is included in PHP5?
I just finished "SQLite"
http://www.bookpool.com/sm/067232685X
and has helped me a lot, then the deltas in the web site helps to
stay in sync with 3.x.
I saw in Ama
Hi,
Is there any know book in print for sqlite that is included in PHP5?
?v=glance&n
>=283155&v=glance
>
> 800+ pages, all functions work -- no issues found.
(...)
> nor with any of dozens of other pdf's that i've downloaded/read/deleted..
> Have you tried the sqlite book with version 7?
I can read PDF files with acroread 7. No problem th
I picked up a copy and it does cover the version 2 API. I'm still
working my way through the concepts part, so I'll see what the API part
is like in a bit.
Joe
Dan Kennedy wrote:
I'm 99% certain this book covers the sqlite v2 C/C++ API. Which is
similar, but not exactly the same as v3 (the cu
El Jueves, 10 de Noviembre de 2005 11:59, escribió:
(...)
>
> Not sure what you mean --
> I've not experienced any issues with Version 7.
Try this:
http://www.amazon.com/exec/obidos/tg/detail/-/B0009F1YD8/qid=1131650560/sr=8-2/ref=pd_bbs_2/104-4273541-2514323?v=glance&s=books&n=507846
After y
Alfredo Cole wrote:
El Jueves, 10 de Noviembre de 2005 11:33, escribió:
> Alfredo Cole wrote:
> > El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió:
> > > I'm looking for a good tutorial (online or paper) to help me get the
> > > concepts behind using the C/C++ API. Could any
Reid Thompson wrote:
Alfredo Cole wrote:
El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió:
> I'm looking for a good tutorial (online or paper) to help me get the
> concepts behind using the C/C++ API. Could anyone recommend the
book by
> Chris Newman "SQLite: A practical gui
El Jueves, 10 de Noviembre de 2005 11:33, escribió:
> Alfredo Cole wrote:
> > El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió:
> > > I'm looking for a good tutorial (online or paper) to help me get the
> > > concepts behind using the C/C++ API. Could anyone recommend the book
Alfredo Cole wrote:
El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió:
> I'm looking for a good tutorial (online or paper) to help me get the
> concepts behind using the C/C++ API. Could anyone recommend the book by
> Chris Newman "SQLite: A practical guide to using, administerin
I'm 99% certain this book covers the sqlite v2 C/C++ API. Which is
similar, but not exactly the same as v3 (the current). The other
APIs it covers, TCL and PHP, I think are still pretty much the same.
That said the book is pretty readable.
--- Joe Halpin <[EMAIL PROTECTED]> wrote:
> I'm looki
On 11/10/05, Joe Halpin <[EMAIL PROTECTED]> wrote:
> I'm looking for a good tutorial (online or paper) to help me get the
> concepts behind using the C/C++ API. Could anyone recommend the book by
> Chris Newman "SQLite: A practical guide to using, administering and
> programming the database bundle
El Miércoles, 9 de Noviembre de 2005 14:21, Joe Halpin escribió:
> I'm looking for a good tutorial (online or paper) to help me get the
> concepts behind using the C/C++ API. Could anyone recommend the book by
> Chris Newman "SQLite: A practical guide to using, administering and
> programming t
I'm looking for a good tutorial (online or paper) to help me get the
concepts behind using the C/C++ API. Could anyone recommend the book by
Chris Newman "SQLite: A practical guide to using, administering and
programming the database bundled with PHP5"?
I'm looking primarily to use the API rat
Bertrand Mansion wrote:
Tiago Dionizio wrote:
I just found that there is a book about SQLite and thought you would
like to know.
link to page: http://www.quepublishing.com/title/067232685X
I prefer to wait for DR Hipp's book... :)
I'm too busy writing software to take time to write a book right
no
Tiago Dionizio wrote:
>I just found that there is a book about SQLite and thought you would
>like to know.
>
>link to page: http://www.quepublishing.com/title/067232685X
>
>Book Description
>
>SQLite is a small, fast, embeddable database. What makes it popular is
>the combination of the database e
I just found that there is a book about SQLite and thought you would
like to know.
link to page: http://www.quepublishing.com/title/067232685X
Book Description
SQLite is a small, fast, embeddable database. What makes it popular is
the combination of the database engine and interface into a singl
38 matches
Mail list logo