在表格中添加列[重复]

Question

This question already has an answer here:

• Add a new column in all mysql tables 1 answer

I want to add a common column in all tables in a database

For example:

I want to insert the column TENANT_ID in all tables in database

How can i do that.

</div>

Answer 1

yes you can add it

if you have list of table in array

$column_name = 'TENANT_ID';
$size = '';
foreach($all_table_name as $each_table_name) {
   mysql_query("ALTER TABLE {$each_table_name} ADD {$column_name} VARBINARY({$size})");
}

above code i just skilton you have to set accourding to your code.