我们如何将 LPAD() 或 RPAD() 函数与 MySQL 表的列中的值一起使用？

mysql> Select Name, LPAD(Name,10,'*') from student;

+---------+-------------------+
| Name    | LPAD(Name,10,'*') |
+---------+-------------------+
| Gaurav  | 淫乱*Gaurav        |
| Aarav   | 淫乱**Aarav        |
| Harshit | 淫乱Harshit        |
| Gaurav  | 淫乱*Gaurav        |
| Yashraj | 淫乱Yashraj        |
+---------+-------------------+
5 rows in set (0.08 sec)

mysql> Select Name, RPAD(Name,10,'*') from student;

+---------+-------------------+
| Name    | RPAD(Name,10,'*') |
+---------+-------------------+
| Gaurav  | Gaurav淫乱*        |
| Aarav   | Aarav淫乱**        |
| Harshit | Harshit淫乱        |
| Gaurav  | Gaurav淫乱*        |
| Yashraj | Yashraj淫乱        |
+---------+-------------------+

5 rows in set (0.00 sec)

mysql> Select Name, RPAD(LPAD(Name,10,'* '),14,'* ') from student;

+---------+----------------------------------+
| Name    | RPAD(LPAD(Name,10,'* '),14,'* ') |
+---------+----------------------------------+
| Gaurav  | * * Gaurav* *                    |
| Aarav   | * * *Aarav* *                    |
| Harshit | * *Harshit* *                    |
| Gaurav  | * * Gaurav* *                    |
| Yashraj | * *Yashraj* *                    |
+---------+----------------------------------+

5 rows in set (0.00 sec)