{"url":"https://tboffice.hatenadiary.jp/entry/20110429/1304090951","width":"100%","image_url":null,"categories":["mysql"],"author_name":"tboffice","author_url":"https://blog.hatena.ne.jp/tboffice/","published":"2011-04-29 00:29:11","version":"1.0","blog_title":"\u691c\u8a0e\uff01\u76ee\u8ad6\u898b\u691c\u8a0e\u59d4\u54e1\u4f1a","description":"\u63a2\u3059\u306e\u304c\u9762\u5012\u306a\u306e\u3067\u30e1\u30e2 MySQL\u306b\u7279\u5b9a\u6587\u5b57\u5217\u3067\u4e0d\u8db3\u6841\u306e\u6587\u5b57\u3092\u57cb\u3081\u308b\u95a2\u6570\u304c\u3042\u308b select lpad(id , 3 ,0); id\u306e\u4e2d\u8eab\u304c1\u306e\u6642\u306f001\u306b\u300111\u306e\u6642\u306f011\u306b\u306a\u308b lpad\u3082\u3042\u308b\u3068\u3044\u3046\u3053\u3068\u306frpad\u3082\u3042\u308b \u8a73\u3057\u304f\u306f http://dev.mysql.com/doc/refman/5.1/ja/string-functions.html","blog_url":"https://tboffice.hatenadiary.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftboffice.hatenadiary.jp%2Fentry%2F20110429%2F1304090951\" title=\"\u6570\u5b57\u30920\u3067\u57cb\u3081\u308b - \u691c\u8a0e\uff01\u76ee\u8ad6\u898b\u691c\u8a0e\u59d4\u54e1\u4f1a\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","provider_name":"Hatena Blog","title":"\u6570\u5b57\u30920\u3067\u57cb\u3081\u308b","provider_url":"https://hatena.blog","type":"rich"}