tanak score 7
2018/02/20 12:47 投稿
| `cast()`で解決しました。 |
| ```sql |
| select |
| count(*) col1, |
| concat(1, 'a') col2, |
| concat(cast(count(*) as |
| concat(cast(count(*) as char), 'a') col3 |
| from |
| dual |
| ``` |
| 参考 |
| [https://stackoverflow.com/questions/38198554/concat-string-with-select-count-value-mysql](https://stackoverflow.com/questions/38198554/concat-string-with-select-count-value-mysql) |
