Počet záznamov v tabuľke
PHP
<?php
$result = mysql_query("SELECT * FROM pouzivatelia");
$num_rows = mysql_num_rows($result);
echo "Počet riadkov: " . $num_rows;
?>
Perl
$query = $db->prepare("SELECT * FROM pouzivatelia");
$query->execute;
$num_rows = $query->rows;
print "Počet riadkov: " . $num_rows;
Python
cursor.execute ("SELECT * FROM pouzivatelia")
while (1):
row = cursor.fetchone ()
if row == None:
break
print "%s, %s" % (row[0], row[1])
print "Počet riadkov: %d" % cursor.rowcount