php批量修改mysql表结构-php开发知识文章-编程文章分享

本文主要介绍了php批量修改mysql表结构的方法。分享给大家，给大家做个参考。一起跟随小编过来看看吧

set_time_limit(0); //不限制执行时间
$con = mysql_connect("localhost", "root", "123456");//连接mysql
$dbname = "user";
if ($con) {
    if (mysql_select_db($dbname, $con)) {
        $sql = "show tables like 'pre_tb_%'";
        $ret = mysql_query($sql);
        while ($row = mysql_fetch_assoc($ret)) {
            $info[] = $row;
        }
        foreach ($info as $v) {
            $chidarr[] = substr($v['Tables_in_multiopen (pre_tb_%)'], 7);//获取标记号
        }
        foreach ($chidarr as $val) {
            $tabname = 'stat_adclick_' . $val;
            $sql = "alter table $tabname add column c2 int default 0 after p";
            mysql_query($sql);
            $sql = "alter table $tabname DROP PRIMARY KEY";
            mysql_query($sql);
            $sql = "alter table $tabname add primary key(c2,p)";
            mysql_query($sql);
            $sql = "alter table $tabname drop index old_index";
            mysql_query($sql);
            $sql = "create index idx_newincex on $tabname (c2,p)";
            mysql_query($sql);
        }
    }
}
mysql_close($con);

以上php批量修改mysql表结构得方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持本站。

set_time_limit — 设置脚本最大执行时间

php批量修改mysql表结构

相关推荐

请登录