Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL SPACE() Function

Concept visual

MySQL SPACE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return a string with 10 space characters:

Select

SPACE(10);

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

MySQL SPACE() Function

Concept visual

MySQL SPACE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return a string with 10 space characters:

Select

SPACE(10);

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

MySQL SPACE() Function

MySQL SPACE() Function

Example

Select

Definition and Usage

Syntax

Space(

Parameter Values

Parameter

Description number

Technical Details

Works in:

Previous

Next

MySQL SPACE() Function

MySQL SPACE() Function

Example

Select

Definition and Usage

Syntax

Space(

Parameter Values

Parameter

Description number

Technical Details

Works in:

Previous

Next