Jmnote bot (토론 | 기여) 잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight)) |
|||
| 7번째 줄: | 7번째 줄: | ||
==POSIX Shell== | ==POSIX Shell== | ||
< | <syntaxhighlight lang='bash'> | ||
FRUITS="Banana Orange Apple Orange Orange " | FRUITS="Banana Orange Apple Orange Orange " | ||
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' | echo $FRUITS | tr ' ' '\n' | grep -c 'Orange' | ||
# 3 | # 3 | ||
</ | </syntaxhighlight> | ||
==PHP== | ==PHP== | ||
[[category: PHP]] | [[category: PHP]] | ||
{{참고|PHP array_count_value()}} | {{참고|PHP array_count_value()}} | ||
< | <syntaxhighlight lang='PHP'> | ||
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;})); | ||
| 23번째 줄: | 23번째 줄: | ||
echo array_count_value($fruits, 'Orange'); | echo array_count_value($fruits, 'Orange'); | ||
# 3 | # 3 | ||
</ | </syntaxhighlight> | ||
< | <syntaxhighlight lang='PHP'> | ||
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | $fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | ||
$acvs = array_count_values($fruits); | $acvs = array_count_values($fruits); | ||
echo $acvs['Orange']; | echo $acvs['Orange']; | ||
# 3 | # 3 | ||
</ | </syntaxhighlight> | ||
==Python== | ==Python== | ||
[[category: Python]] | [[category: Python]] | ||
{{참고|Python count()}} | {{참고|Python count()}} | ||
< | <syntaxhighlight lang='Python'> | ||
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange'] | ||
print( fruits.count('Orange') ) | print( fruits.count('Orange') ) | ||
# 3 | # 3 | ||
</ | </syntaxhighlight> | ||
==Perl== | ==Perl== | ||
[[category:Perl]] | [[category:Perl]] | ||
< | <syntaxhighlight lang='perl'> | ||
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange'); | ||
print $k = grep { $_ eq 'Orange' } @fruits; | print $k = grep { $_ eq 'Orange' } @fruits; | ||
# 3 | # 3 | ||
</ | </syntaxhighlight> | ||
==SQL== | ==SQL== | ||
| 52번째 줄: | 52번째 줄: | ||
===MySQL=== | ===MySQL=== | ||
[[category: MySQL]] | [[category: MySQL]] | ||
< | <syntaxhighlight lang='console'> | ||
mysql> SELECT * FROM fruits; | mysql> SELECT * FROM fruits; | ||
+--------+ | +--------+ | ||
| 64번째 줄: | 64번째 줄: | ||
+--------+ | +--------+ | ||
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'; | ||
+----------+ | +----------+ | ||
| 73번째 줄: | 73번째 줄: | ||
+----------+ | +----------+ | ||
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]] | ||
2020년 11월 2일 (월) 02:32 판
- 다른 뜻에 대해서는 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
2 PHP
PHP
Copy
function array_count_value($arr, $val) {
return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
}
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
echo array_count_value($fruits, 'Orange');
# 3
PHP
Copy
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
$acvs = array_count_values($fruits);
echo $acvs['Orange'];
# 3
3 Python
Python
Copy
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
print( fruits.count('Orange') )
# 3
4 Perl
Perl
Copy
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
print $k = grep { $_ eq 'Orange' } @fruits;
# 3
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)