From f227de702ba85e78681194d0e050ed637646a944 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 22 Jul 2021 12:57:48 +0800 Subject: [PATCH] case on update --- sql/core_group.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_group.sql b/sql/core_group.sql index 0c6b4c46..8e4cb19f 100644 --- a/sql/core_group.sql +++ b/sql/core_group.sql @@ -14,6 +14,6 @@ ALTER TABLE core_group ADD COLUMN type int(11) NOT NULL DEFAULT 0; ALTER TABLE core_group ADD COLUMN leader int(11) NOT NULL default 0; ALTER TABLE core_group ADD COLUMN is_system int(2) NOT NULL default 0; -Update core_group set display_name = name where display_name = ''; +UPDATE core_group SET display_name = name WHERE display_name = ''; ALTER TABLE core_group ADD INDEX lookup_leader (leader); \ No newline at end of file -- 2.39.2