「MySQL」指定回数の半角スペースを生成する

2022年1月6日

環境
Windows10 64bit
MySQL 8.0.27

書式
SPACE( 数値 )
SPACE関数を使用することで、数値で指定した数だけの半角スペースを生成します

使用例1
半角スペースを生成します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT SPACE( 5 ) result;
+----------+
|  result |
+----------+
| |
+----------+
1 row in set (0.00 sec)
mysql> SELECT SPACE( 5 ) result; +----------+ |  result | +----------+ | | +----------+ 1 row in set (0.00 sec)
mysql> SELECT SPACE( 5 ) result;
+----------+
|  result |
+----------+
|          |
+----------+
1 row in set (0.00 sec)

半角スペースの長さを計算します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT LENGTH(SPACE( 5 )) result;
+----------+
|  result |
+----------+
| 5 |
+----------+
1 row in set (0.02 sec)
mysql> SELECT LENGTH(SPACE( 5 )) result; +----------+ |  result | +----------+ | 5 | +----------+ 1 row in set (0.02 sec)
mysql> SELECT LENGTH(SPACE( 5 )) result;
+----------+
|  result |
+----------+
|        5 |
+----------+
1 row in set (0.02 sec)

使用例2
半角スペースでシングルクォートで囲みます

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT QUOTE(SPACE(5)) result;
+----------+
|  result |
+----------+
| ' ' |
+----------+
1 row in set (0.04 sec)
mysql> SELECT QUOTE(SPACE(5)) result; +----------+ |  result | +----------+ | ' ' | +----------+ 1 row in set (0.04 sec)
mysql> SELECT QUOTE(SPACE(5)) result;
+----------+
|  result |
+----------+
| '     '  |
+----------+
1 row in set (0.04 sec)

シングルクォートで囲んだ文字列の長さを計算します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT LENGTH(QUOTE(SPACE(5))) result;
+----------+
|  result |
+----------+
| 7 |
+----------+
1 row in set (0.00 sec)
mysql> SELECT LENGTH(QUOTE(SPACE(5))) result; +----------+ |  result | +----------+ | 7 | +----------+ 1 row in set (0.00 sec)
mysql> SELECT LENGTH(QUOTE(SPACE(5))) result;
+----------+
|  result |
+----------+
|        7 |
+----------+
1 row in set (0.00 sec)

使用例3
文字列と半角スペースを結合します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT CONCAT( 'study', SPACE(3), 'skill',space(2),'become') result;
+-----------------------+
| result |
+-----------------------+
| study skill become |
+-----------------------+
1 row in set (0.00 sec)
mysql> SELECT CONCAT( 'study', SPACE(3), 'skill',space(2),'become') result; +-----------------------+ | result | +-----------------------+ | study skill become | +-----------------------+ 1 row in set (0.00 sec)
mysql> SELECT CONCAT( 'study', SPACE(3), 'skill',space(2),'become') result;
+-----------------------+
| result                |
+-----------------------+
| study   skill  become |
+-----------------------+
1 row in set (0.00 sec)

 

MySQL

Posted by arkgame