]> git.sur5r.net Git - bacula/docs/commit
projects / bacula / docs / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9c02052) | patch
Not all databases allow you to refer to field in an "AS field" clause.
authorDan Langille <dan@langille.org>
Sat, 17 Jul 2004 15:49:39 +0000 (15:49 +0000)
committerDan Langille <dan@langille.org>
Sat, 17 Jul 2004 15:49:39 +0000 (15:49 +0000)
commit486e1bf7b537c3d5dac22e967c48398da4a97ebc
tree4b825dc642cb6eb9a060e54bf8d69288fbee4904tree | snapshot
parent9c0205235005fcddcbb98eb45e9d774bdb9242bdcommit | diff
Not all databases allow you to refer to field in an "AS field" clause.
So use count(*) instead of the field name in selects.

Use DISTINCT intead of GROUP BY, because that's what we really want
because this won't work on non-MySQL.
Cloned from http://git.bacula.org/docs