表结构只存在字段573,并不存在字段574
例如这条sql语句~我怎样修改能让数据库不报错并且为不存在的字段574默认为0
SELECT count(`573`) as '573', count(`574`) as '574' FROM `rta_1000005`.`201119_`小菜求教!~
例如这条sql语句~我怎样修改能让数据库不报错并且为不存在的字段574默认为0
SELECT count(`573`) as '573', count(`574`) as '574' FROM `rta_1000005`.`201119_`小菜求教!~
mysql_select_db('库名');
$field = mysql_query('Describe 表名 字段名');
$field = mysql_fetch_array($field);
if($field[0]){
echo 'exist';
}else{
echo 'none';
}
SELECT count(`573`) as '573', 0 as '574' FROM `rta_1000005`.`201119_`可否?
————————————————————————————————
基于CSDN论坛提供的插件扩展功能,自己做了个签名档工具,分享给大家,欢迎技术交流 :)