두찡의 일상

간단하게 id 와 date 타입 컬럼만 있는 테이블 DAYOFWEEK 명령어로 요일을 같이 출력 합니다 SELECT CASE WHEN DAYOFWEEK(access_time) = 1 THEN 1 ELSE 0 END AS isSunday, CASE WHEN DAYOFWEEK(access_time) = 2 THEN 1 ELSE 0 END AS isMonday, CASE WHEN DAYOFWEEK(access_time) = 3 THEN 1 ELSE 0 END AS isTuesday, CASE WHEN DAYOFWEEK(access_time) = 4 THEN 1 ELSE 0 END AS isWednesday, CASE WHEN DAYOFWEEK(access_time) = 5 THEN 1 ELSE 0 END AS..

https://github.com/clucle/cpp_mysql_vs2019 clucle/cpp_mysql_vs2019 mysql-connector with visualstudio. Contribute to clucle/cpp_mysql_vs2019 development by creating an account on GitHub. github.com 1. Download MySQL & make database download MySQL https://dev.mysql.com/downloads/installer/ After installation, Open Workbench. Connect Mysql. 2. Download MySQL Connector8.0 download MySQL Connector cp..