| |||||||||||
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.
|
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho |