varchar对于sum运算符无效,怎么不改数据库能正确运算?谢谢!
zhichu和xiaji字段类型为varchar
$query="select sum(zhichu*xiaji) from shouruzc where id>0";
$result=mysql_fetch_array(mysql_query($query));
$result6[0]得不到sum(zhichu*xiaji) 的和
改成:
$query="select sum(cast(zhichu as bigint)*cast(xiaji as bigint)) from shouruzc where id>0";
还是没用,求高手帮忙,谢谢!