如何知道php脚本中的名称是指mysql表还是mysql视图
I can select all tables in a database like this
我可以像这样选择数据库中的所有表
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
And following code populate $return variable which can be used to backup the database.
后面的代码填充$return变量,可以用来备份数据库。
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);
$return.= 'DROP TABLE IF EXISTS '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";
for ($i = 0; $i < $num_fields; $i++)
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++)
{
$row[$j] = addslashes($row[$j]);
$row[$j] = ereg_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}
My database has two mysql views. Above code generates "INSERT INTO...." string even for mysql views which I need to avoid. So before starting the 'for loop' to generate "INSERT INTO.." values I need to check if $table is actually a mysql table or view. How to identify whether a name refers to mysql table or mysql view?
我的数据库有两个mysql视图。上面的代码生成字符串“插入....”甚至对mysql的观点,我需要避免。因此,在启动“for循环”生成“INSERT INTO.”值之前,我需要检查$table是否实际上是一个mysql表或视图。如何识别名称是指mysql表还是mysql视图?
3 个解决方案
#1
17
SHOW [FULL] TABLES
The FULL
modifier is supported such that SHOW FULL TABLES
displays a second output column. Values for the second column are BASE TABLE
for a table and VIEW
for a view.
支持完整修饰符,以便显示完整表显示第二个输出列。第二列的值是表的基表和视图的视图。
更多相关文章
- PO,Hibernate,VO,struts,spring,hibernate,Jsp,Oracle,mysql,mss
- MySql sqlstate代码大全(转载)
- MySQL视图-(视图创建,修改,删除,查看,更新数据)
- ng- repeat显示的行等于no属性,甚至不显示html视图上的数据
- 如何更模块化地编写jQuery代码?
- [生活娱乐] 从后端室友那学来的代码
- js金额数字格式化实现代码(三位加逗号处理保留两位置小数)
- Aptana Studio 3 IDE中有运行JavaScript代码的方法吗?
- 如何在JavaScript中编写适当的OOP代码?