mysql count

最新推荐文章于 2025-12-29 17:07:25 发布

原创最新推荐文章于 2025-12-29 17:07:25 发布 · 406 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #sql #query

require_once("globals.php");

$sql = "SELECT count(*) AS cnt FROM `tbl_mpls-get-smlsp`";
$result = @mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
echo $row['cnt'].'<br/>';

$sql = "SELECT count(*) AS cnt FROM `tbl_mpls-get-smlsp` WHERE LENGTH(`name`)>1";
$result = @mysql_query($sql);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
echo $row['cnt'].'<br/>';