protected function execute(Input $input, Output $output)
{
ini_set('memory_limit', '5120M');
echo date("Y-m-d H:i:s")."开始\n";
$dade = "项目类别";//查询信息
//获得数据库所有表
$data = Db::connect("csdade")->query("select TABLE_NAME from information_schema.COLUMNS GROUP BY TABLE_NAME;");
foreach($data as $key=>$it){
//获得表所有字段
$COLUMN = Db::connect("csdade")->query("select COLUMN_NAME from information_schema.COLUMNS where TABLE_NAME='{$it['TABLE_NAME']}'");
foreach ($COLUMN as $key=>$it2){
try {
//查询
$shu = Db::connect("csdade")->query("select top 1 {$it2['COLUMN_NAME']} from {$it['TABLE_NAME']} where {$it2['COLUMN_NAME']} = '{$dade}'");
if(!empty(count($shu))){
echo "{$it['TABLE_NAME']}\n";
}
} catch (\Exception $e) {
}
}
}
echo date("Y-m-d H:i:s")."结束\n";
return true;
}
php数据库全网查询数据
于 2024-04-28 18:05:45 首次发布