Detailed explanation of how to batch modify table structure in PHP-PHP Tutorial-php.cn

Detailed explanation of how to batch modify table structure in PHP

*文

Release： 2023-03-19 07:24:01

Original

1698 people have browsed it

How does PHP modify the table structure in batches? Today, the editor will bring you an example of batch modification of table structure in PHP. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor to have a look, I hope it will be helpful to everyone.

No more nonsense, just go to the code

<?php
set_time_limit(0);
$con = mysql_connect("localhost", "root", "root");
$dbname = "db";
if ($con) {
 if (mysql_select_db($dbname, $con)) {
  $sql = "show tables like &#39;pre_tb_%&#39;";
  $ret = mysql_query($sql);
  while($row = mysql_fetch_assoc($ret)){
   $info1[] = $row;
  }
  foreach ($info1 as $v) {
   $chidarr1[] = substr($v[&#39;Tables_in_multiopen (pre_tb_%)&#39;],7);//获取标记号
  }
  foreach ($chidarr1 as $val) {
   $tabname = &#39;stat_adclick_&#39;.$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);
?>

Copy after login

Related recommendations:

Detailed explanation of how php7 implements MongoDB fuzzy query

Analysis and resolution of form token errors under ThinkPHP

Detailed explanation of how PHP implements importing csv files into the database

The above is the detailed content of Detailed explanation of how to batch modify table structure in PHP. For more information, please follow other related articles on the PHP Chinese website!