跳转到主要内容

LPAD

Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters.

Syntax​

LPAD(str,len,padstr)

Arguments​

ArgumentsDescription
strThe string.
lenThe length.
padstrThe pad string.

Return Type​

A number data type value.

Examples​

SELECT LPAD('hi',4,'??');
+---------------------+
| LPAD('hi', 4, '??') |
+---------------------+
| ??hi                |
+---------------------+

SELECT LPAD('hi',1,'??');
+---------------------+
| LPAD('hi', 1, '??') |
+---------------------+
| h                   |
+---------------------+