SPACE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a string consisting of the requested number of space characters.
USAGE
SPACE(count)
Argument Name | Description |
|---|---|
| The number of spaces desired |
DETAILS
SPACE()is a string function that returns the requested number of space characters.
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT QUOTE(SPACE(3));
+-----------------+
| QUOTE(SPACE(3)) |
+-----------------+
| ' ' |
+-----------------+
SELECT CONCAT('x', SPACE(10), 'y');
+-----------------------------+
| CONCAT('x', SPACE(10), 'y') |
+-----------------------------+
| x y |
+-----------------------------+