Skip to main content

Three patterns to use "if else" statement in dos/batch scripts

· One min read
  • Pattern #1
@echo off
set var=b
if "%var%" EQU "a" (echo 1) else if "%var%" EQU "b" (  echo 2) else if "%var%" EQU "c" (  echo 3)
  • Pattern #2
@echo off
set var=b
if "%var%" EQU "a" (
  echo 1
) else if "%var%" EQU "b" (
  echo 2
) else if "%var%" EQU "c" (
  echo 3
)
  • Pattern #3
@echo off
set var=b
if "%var%" EQU "a" (
  echo 1
) ^
else if "%var%" EQU "b" (
  echo 2
) ^
else if "%var%" EQU "c" (
  echo 3
)

Use regex to match and replace in MySql 8.0+ or MariaDB

· One min read
<code class="sql">UPDATE server_list_server
  SET world_id=regexp_replace(ip,'wg(\\d+)\.glwsy\.szgla\.com;?','\\1')
  WHERE ip REGEXP 'wg(\\d+)\.glwsy\.szgla\.com;?'
    AND world_id!=regexp_replace(ip,'wg(\\d+)\.glwsy\.szgla\.com;?','\\1');
  • REGEXP
  • regexp_replace
  • \\1 is the placeholder for matched group
ClustrMaps