更新所有NULL字段MySQL [英] update all NULL fields MySQL

问题描述

我想将一个表中的所有NULL字段更新为0.当然

I'd like to update all NULL fields in one table to 0. Of course

UPDATE mytable SET firstcol=0 WHERE firstcol IS NULL 

会做这份工作.但是我想知道是否有比仅在每一列都覆盖这一行更聪明的解决方案.

would do the job. But I wonder if there´s a smarter solution than just c&p this line for every column.

推荐答案

您可以仅将ALTER列添加到NOT NULL DEFAULT 0吗?

Can you just ALTER the columns to NOT NULL DEFAULT 0?

您可以按照 MySQL文档:

您可以在单个ALTER TABLE语句中发出多个ADD，ALTER，DROP和CHANGE子句，以逗号分隔.这是对标准SQL的MySQL扩展，每个ALTER TABLE语句仅允许每个子句中的一个.

You can issue multiple ADD, ALTER, DROP, and CHANGE clauses in a single ALTER TABLE statement, separated by commas. This is a MySQL extension to standard SQL, which allows only one of each clause per ALTER TABLE statement.

这篇关于更新所有NULL字段MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！