Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SPACE(N) mysql function

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 108
    Comment on it

    SPACE(N)

    If you want to add spaces in a string then you can use SPACE function of mysql. SPACE function returns a string consisting of N space characters means SPACE will returns the white space equal to passed argument n, where n is a integer value means if you passed 5 as argument with this function then this returns 5 spaces.

    Here is a example-

    mysql> SELECT SPACE(5);
    +----------+
    | SPACE(5) |
    +----------+
    |          |
    +----------+
    1 row in set (0.00 sec)
    
    mysql> SELECT SPACE(15);
    +-----------------+
    | SPACE(15)       |
    +-----------------+
    |                 |
    +-----------------+
    1 row in set (0.00 sec)
    
    mysql> SELECT SPACE(30);
    +--------------------------------+
    | SPACE(30)                      |
    +--------------------------------+
    |                                |
    +--------------------------------+
    1 row in set (0.00 sec)
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: