Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
 
For 2021 - online Python 3 training - see ((here)).

Our plans were to retire in summer 2020 and see the world, but Coronavirus has lead us into a lot of lockdown programming in Python 3 and PHP 7.
We can now offer tailored online training - small groups, real tutors - works really well for groups of 4 to 14 delegates. Anywhere in the world; course language English.

Please ask about private 'maintenance' training for Python 2, Tcl, Perl, PHP, Lua, etc.
count even or odd objects

Posted by liviu_loe (liviu_loe), 24 November 2004
i have a database where i want to select objects that are pairs, even or odd, when i count this elements.
something like:
select  count(*) from table group by..., and i want to declare these counts as even or odd.
is it possible, and how , with statements of mysql?
thank you very much

Posted by admin (Graham Ellis), 24 November 2004
If I understand this right, you want to take a different action depending on whether a count is odd of even?  Personally, I would tend to use a simple mysql statement:
   select count(biid) from b_btab
and test the result returned in my program - Perl, PHP, Java, Python and C all have the "%" operator for the purpose.



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2022: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho