summaryrefslogtreecommitdiff
path: root/sqlupdate
diff options
context:
space:
mode:
author段冬梅 <[email protected]>2018-12-09 17:13:18 +0800
committer段冬梅 <[email protected]>2018-12-09 17:13:18 +0800
commitfb4924680edff50eff3f149ffa0c6f064e459c2d (patch)
tree164c9e8ac1a2c1fd896b404fa8fbfe2a23b31c35 /sqlupdate
nfs sources
Diffstat (limited to 'sqlupdate')
-rw-r--r--sqlupdate/update_video_spell_error.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sqlupdate/update_video_spell_error.sql b/sqlupdate/update_video_spell_error.sql
new file mode 100644
index 0000000..2b38bea
--- /dev/null
+++ b/sqlupdate/update_video_spell_error.sql
@@ -0,0 +1,2 @@
+update function_region_dict t set t.config_region_value=insert(t.config_region_value,POSITION('vedio' in t.config_region_value),5,'video') where t.config_region_value like '%vedio%';
+update sys_menu s set s.`code`=insert(s.`code`,POSITION('vedio' in s.`code`),5,'video') where s.`code` like '%vedio%';