MySQL SPACE() Function

Example

Return a string with 10 space characters:

SELECT SPACE(10);
Try it Yourself »

Definition and Usage

The SPACE() function returns a string of the specified number of space characters.

Syntax

SPACE(number)

Parameter Values

Parameter Description
number Required. The number of space characters to return

Technical Details

Works in: From MySQL 4.0

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.