List:General Discussion« Previous MessageNext Message »
From:Ashley M. Kirchner Date:June 1 2007 12:06am
Subject:Padding result
View as plain text  
    Is there a way to automatically pad a query result?  For example:

    select id, user from table

    +-----+--------------+
    |  id | user         |
    +-----+--------------+
    |   3 | Tinker Bell  |
    |  11 | Peter Pan    |
    |   7 | Dumbo        |
    | 121 | Mickey Mouse |
    +-----+--------------+

    What I really want is:

    +-------+--------------+
    |    id | user         |
    +-------+--------------+
    | 10003 | Tinker Bell  |
    | 10011 | Peter Pan    |
    | 10007 | Dumbo        |
    | 10121 | Mickey Mouse |
    +-------+--------------+


-- 
W | It's not a bug - it's an undocumented feature.
  +--------------------------------------------------------------------
  Ashley M. Kirchner <mailto:ashley@stripped>   .   303.442.6410 x130
  IT Director / SysAdmin / Websmith             .     800.441.3873 x130
  Photo Craft Imaging                       .     3550 Arapahoe Ave. #6
  http://www.pcraft.com ..... .  .    .       Boulder, CO 80303, U.S.A. 


Thread
Padding resultAshley M. Kirchner1 Jun
  • Re: Padding resultBaron Schwartz1 Jun
  • Re: Padding resultBaron Schwartz1 Jun
  • Re: Padding resultMogens Melander1 Jun