(→Perl) |
|||
| (사용자 3명의 중간 판 9개는 보이지 않습니다) | |||
| 5번째 줄: | 5번째 줄: | ||
;count() | ;count() | ||
;array_count_value() | ;array_count_value() | ||
==POSIX Shell== | |||
<syntaxhighlight lang='bash' run> | |||
FRUITS="Banana Orange Apple Orange Orange " | |||
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' # 3 | |||
</syntaxhighlight> | |||
==PHP== | ==PHP== | ||
[[category: PHP]] | [[category: PHP]] | ||
< | {{참고|PHP array_count_value()}} | ||
<syntaxhighlight lang='PHP' run> | |||
function array_count_value($arr, $val) { | function array_count_value($arr, $val) { | ||
return count(array_filter($arr, function($v) use($val) {return $v==$val;})); | return count(array_filter($arr, function($v) use($val) {return $v==$val;})); | ||
} | } | ||
$fruits = | $fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']; | ||
echo array_count_value($fruits, 'Orange'); | echo array_count_value($fruits, 'Orange'); # 3 | ||
# 3 | </syntaxhighlight> | ||
</ | <syntaxhighlight lang='PHP' run> | ||
< | $fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']; | ||
$fruits = | $counts = array_count_values($fruits); | ||
$ | echo $counts['Orange']; # 3 | ||
echo $ | </syntaxhighlight> | ||
# 3 | |||
</ | |||
==Python== | ==Python== | ||
[[category: Python]] | [[category: Python]] | ||
{{참고|Python count()}} | {{참고|Python count()}} | ||
< | <syntaxhighlight lang='Python' run> | ||
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | ||
print( fruits.count('Orange') ) | print( fruits.count('Orange') ) # 3 | ||
# 3 | </syntaxhighlight> | ||
</ | |||
==Perl== | |||
[[category:Perl]] | |||
<syntaxhighlight lang='perl' run> | |||
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | |||
print $k = grep { $_ eq 'Orange' } @fruits; # 3 | |||
</syntaxhighlight> | |||
==SQL== | ==SQL== | ||
{{참고|SQL COUNT()}} | |||
[[category: SQL]] | [[category: SQL]] | ||
===MySQL=== | ===MySQL=== | ||
[[category: MySQL]] | [[category: MySQL]] | ||
< | <syntaxhighlight lang='console'> | ||
mysql> SELECT * FROM fruits; | mysql> SELECT * FROM fruits; | ||
+--------+ | +--------+ | ||
| 48번째 줄: | 60번째 줄: | ||
+--------+ | +--------+ | ||
5 rows in set (0.00 sec) | 5 rows in set (0.00 sec) | ||
</ | </syntaxhighlight> | ||
< | <syntaxhighlight lang='console'> | ||
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange'; | mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange'; | ||
+----------+ | +----------+ | ||
| 57번째 줄: | 69번째 줄: | ||
+----------+ | +----------+ | ||
1 row in set (0.00 sec) | 1 row in set (0.00 sec) | ||
</ | </syntaxhighlight> | ||
==같이 보기== | ==같이 보기== | ||
*[[array_count_values()]] | *[[array_count_values()]] | ||
*[[array length]] | *[[array length]] | ||
2021년 4월 14일 (수) 19:11 기준 최신판
- 다른 뜻에 대해서는 array length 문서를 참조하십시오.
- 다른 뜻에 대해서는 PHP count() 문서를 참조하십시오.
- count()
- array_count_value()
1 POSIX Shell[ | ]
Bash
Copy
FRUITS="Banana Orange Apple Orange Orange "
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' # 3
Loading
2 PHP[ | ]
PHP
Copy
function array_count_value($arr, $val) {
return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
}
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'];
echo array_count_value($fruits, 'Orange'); # 3
Loading
PHP
Copy
$fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'];
$counts = array_count_values($fruits);
echo $counts['Orange']; # 3
Loading
3 Python[ | ]
Python
Copy
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
print( fruits.count('Orange') ) # 3
Loading
4 Perl[ | ]
Perl
Copy
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
print $k = grep { $_ eq 'Orange' } @fruits; # 3
Loading
5 SQL[ | ]
5.1 MySQL[ | ]
Console
Copy
mysql> SELECT * FROM fruits;
+--------+
| value |
+--------+
| Banana |
| Orange |
| Apple |
| Orange |
| Orange |
+--------+
5 rows in set (0.00 sec)
Console
Copy
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
+----------+
| COUNT(*) |
+----------+
| 3 |
+----------+
1 row in set (0.00 sec)