DATABASE/MySQL
현재날짜+텍스트or숫자 출력하기
스티브
2018. 12. 10. 20:34
mysql> SELECT CONCAT(curdate()+0, '11');
+---------------------------+
| CONCAT(curdate()+0, '11') |
+---------------------------+
| 2018121011 |
+---------------------------+
1 row in set (0.00 sec)
mysql> SELECT CONCAT(curdate()+0, '숫자');
+-------------------------------+
| CONCAT(curdate()+0, '숫자') |
+-------------------------------+
| 20181210숫자 |
+-------------------------------+
1 row in set (0.00 sec)