同一查询中多个表的ALTER列 [英] ALTER columns from multiple tables in same query

问题描述

是否可以在一个查询中更改多个表中具有相同列类型的相同列名?

Is there a way to change same column name with same column type in multiple tables in one query?

类似这样的东西:

ALTER TABLE 
(SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE 'data_by_%_month_%'
AND TABLE_SCHEMA='db_name') 
MODIFY column1 INT(20) NOT NULL;

推荐答案

不，不是单独使用ALTER TABLE的情况.预计ALTER TABLE语句将接收一张表.

No, not with ALTER TABLE alone. It is expected for the ALTER TABLE statement to receive one table.

请参见文档.它在那里不希望有表达式.

See the docs. It doesn't expect an expression there.

您当然可以编写一个程序，根据您的SELECT查询创建多个ALTER TABLE语句.

You can of course write a program that creates multiple ALTER TABLE statements based on your SELECT Query.

这篇关于同一查询中多个表的ALTER列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！