Yanor.net/
Wiki
Blog
GitHub
Sandbox
開始行:
* ランダムな文字列の生成 [#y75528ce]
** SUBSTRING('abc,,789',) [#m111527c]
SELECT CONCAT(
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
);
** MD5() [#jd0b4b10]
SELECT SUBSTRING(MD5(RAND()), 1, 4);
MD5()は32桁の16進数を返す。https://dev.mysql.com/doc/refm...
** UUID() [#h4afbbdd]
SELECT UUID();
http://dev.mysql.com/doc/refman/5.6/en/miscellaneous-func...
終了行:
* ランダムな文字列の生成 [#y75528ce]
** SUBSTRING('abc,,789',) [#m111527c]
SELECT CONCAT(
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
SUBSTRING('abcdefghijklmnopqrstuvwxyz012345678...
);
** MD5() [#jd0b4b10]
SELECT SUBSTRING(MD5(RAND()), 1, 4);
MD5()は32桁の16進数を返す。https://dev.mysql.com/doc/refm...
** UUID() [#h4afbbdd]
SELECT UUID();
http://dev.mysql.com/doc/refman/5.6/en/miscellaneous-func...
ページ名: