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:[EMAIL PROTECTED]> . 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]