Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* COUNT() [#e0e28000]
$rs = $rs->search();
print $rs->count;
*** DISTINCTしてCOUNT()する [#hbb92c2c]
↓SELECT COUNT(DISTINCT name) FROM user
$rs = $rs->seach({},{
select => [ { count => { distinct => 'name' } } ],
as => ['count'],
});
print $rs->next->get_column('count');
終了行:
* COUNT() [#e0e28000]
$rs = $rs->search();
print $rs->count;
*** DISTINCTしてCOUNT()する [#hbb92c2c]
↓SELECT COUNT(DISTINCT name) FROM user
$rs = $rs->seach({},{
select => [ { count => { distinct => 'name' } } ],
as => ['count'],
});
print $rs->next->get_column('count');
ページ名: