回答編集履歴
3
修正
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
UPDATE テーブル名 SET カラム名 = NULL
|
6
6
|
|
7
|
-
where TRIM(REPLACE(カラム名, ' ',
|
7
|
+
where TRIM(REPLACE(カラム名, ' ', ' ')) IS NULL
|
8
8
|
|
9
9
|
```
|
10
10
|
|
2
追記
test
CHANGED
@@ -7,3 +7,5 @@
|
|
7
7
|
where TRIM(REPLACE(カラム名, ' ', NULL)) IS NULL
|
8
8
|
|
9
9
|
```
|
10
|
+
|
11
|
+
[FUNCTION REPLACE](https://dev.mysql.com/doc/refman/5.6/ja/string-functions.html#function_replace)
|
1
追記
test
CHANGED
File without changes
|