MySQL RPAD() 函数

用＃{0}＃的右搭载的字符串，总长度为20：

SELECT RPAD("SQL Tutorial", 20, "ABC");

定义和用法

RPAD() 函数右填充一个带有另一个字符串的字符串到一定长度。

笔记：另请参阅LPAD()功能。

RPAD( string, length, rpad_string)

Parameter	Description
string	Required. The original string. If the length of the original string is larger than the length parameter, this function removes the overfloating characters from string
length	Required. The length of the string after it has been right-padded
rpad_string	Required. The string to right-pad to string

工作于：	从 MySQL 4.0 开始