SPACE()

函数说明

SPACE(N) 返回 N 个空格组成的字符串。

语法

1. > SPACE(N)

参数释义

示例

1. > drop table if exists t1;
2. > CREATE TABLE t1
3. (
4. Employee_name VARCHAR(100) NOT NULL,
5. Joining_Date DATE NOT NULL
6. );
7. > INSERT INTO t1
8. (Employee_name, Joining_Date )
9. VALUES
10. ('     Ananya Majumdar', '2000-01-11'),
11. ('   Anushka Samanta', '2002-11-10' ),
12. ('   Aniket Sharma ', '2005-06-11' ),
13. ('   Anik Das', '2008-01-21'  ),
14. ('  Riya Jain', '2008-02-01' ),
15. ('    Tapan Samanta', '2010-01-11' ),
16. ('   Deepak Sharma', '2014-12-01'  ),
17. ('   Ankana Jana', '2018-08-17'),
18. ('  Shreya Ghosh', '2020-09-10') ;
19. > INSERT INTO t1
20. (Employee_name, Joining_Date ) values('     ','2014-12-01');
21. > select * from t1 where Employee_name=space(5);
22. +---------------+--------------+
23. | Employee_name | Joining_Date |
24. +---------------+--------------+
25. |               | 2014-12-01   |
26. +---------------+--------------+