ãªã¬ãªã¬è¨èªå ¨çæã®çæã®åãããããéããã§ããããã ãªã¬ãªã¬SQLã®ä½ãæ¹ãPostgreSQLç·¨ãã«ç¶ãããªã¬ãªã¬SQLã®ä½ãæ¹ãMySQLç·¨ãã¨ããäºã§ MySQLã«ãèªä½ã®SQLé¢æ°(UDF)ãçµã¿è¾¼ãããæ¹ãç°¡åã«ç´¹ä»ãã¾ãã MySQLã¯åã®éããç§ã®SQLãªã®ã§ãªã¬ãªã¬SQLã«ã¯æã£ã¦ããã§ããã ç°¡åã«è¨ãã° select oreore(); select oreore(column1, column2) from table1; èªåã§å®ç¾©ããCè¨èªã®oreoreé¢æ°ãDBã«çµã¿è¾¼ãã§ä½¿ããã¨ããäºã§ãã æçµç®æ¨ã¯ãSQLã®çµæã§JSONãè¿ããã¨æãã¾ãã select json(a, b) from c;ã®çµæ㧠{ "aaa" : 1, "bbb" : "abc" } åºå®å¤ãè¿ãé¢æ° æ©éãåºå®ã§999ãè¿ãé¢æ°ãä½ã£ã¦ã¿ã¾ãã â»ãã¼ã¸ã§ã³ã¯MySQL5.
{{#tags}}- {{label}}
{{/tags}}