mysql_testa_view.php

<?php

$con = mysqli_connect("127.0.0.1", "root", "senha");

$sql = "SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.tables WHERE TABLE_TYPE LIKE 'VIEW'";

$result = mysqli_query($con,$sql);

while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)) {

$sql = "select * from ".$row['TABLE_SCHEMA'].".".$row['TABLE_NAME']." limit 1";

echo $sql."\n";

if(!mysqli_query($con,$sql)){

$msgErro[] = mysqli_error($con);

}

}

system('clear');

if(empty($msgErro)){

echo "\n\n\nTudo certo!\n\n\n";

}else{

echo "\n\n\nTabelas com erros:\n";

print_r($msgErro);

}

mysqli_free_result($result);

mysqli_close($con);