Technology sharing

background

Ob missionem negotiorum, quidam campus ut phone_nomen multas tabulas involvit. In praesenti, multae mensae agros redundantes habent. Sed ager longitudo in praematuro tantum varchar est (100), quod non occurrit necessitates hodiernae Oportet ager longitudo ad varchar aucta (255). Si manually unum temperaveris, centeni tabulae erunt, quae tempus edax est.

consilium

Mutare DDL propositiones quae hunc agrum faciunt in his tabulis requiri

SELECT
concat("ALTER TABLE `",table_name,"` MODIFY COLUMN `phone_name`  varchar(255)  NOT NULL COMMENT '手机名称';")
FROM information_schema.columns
WHERE
table_schema = 'db_lingyejun' and column_name='phone_name' and character_maximum_length < 255 and is_nullable = 'NO';

Mutare DDL constitutiones, quae hunc agrum nullum in his tabulis faciunt

SELECT
concat("ALTER TABLE `",table_name,"` MODIFY COLUMN `phone_name`  varchar(255)  DEFULT NULL COMMENT '手机名称';")
FROM information_schema.columns
WHERE
table_schema = 'db_lingyejun' and column_name='phone_name' and character_maximum_length < 255 and is_nullable = 'YES';

Si hic articulus te adiuvat, da "Ling Yejun" simile, gratias pro auxilio tuo.

Prima pagina:https://www.cnblogs.com/lingyejun/p/18293068