将表名全部改成大写

 

table_name.php  内容

<?

include_once("inc/conn.php");

$connection=OpenConnection();

$FILE_CONTENT="";

$TABLE_ARRAY=mysql_list_tables($MYSQL_DB);

while($TABLE=mysql_fetch_row($TABLE_ARRAY))

{

   $TABLE_NAME=$TABLE[0];

   $TABLE_NAME1=strtoupper($TABLE_NAME);

   $query="ALTER  TABLE $TABLE_NAME RENAME $TABLE_NAME1;";

   echo $query."<br>";

   exequery($connection,$query);

}

echo "OK!";

?>