bro's coding

https://dev.mysql.com/downloads/workbench/ MySQL :: Download MySQL Workbench Select Operating System: Select Operating System… Microsoft Windows Ubuntu Linux Red Hat Enterprise Linux / Oracle Linux Fedora macOS Source Code Select OS Version: All Windows (x86, 64-bit) Recommended Download: Other Downloads: Windows (x86, 64-bit), M dev.mysql.com

https://dev.mysql.com/ MySQL :: Developer Zone MySQL Engineering Blogs MySQL Shell Dump & Load part 4: Dump Instance & Schemas MySQL Shell 8.0.21 comes with two utilities which can be used to perform logical dumps of all the schemas from an instance (util.dumpInstance()) or selected schemas (util.dumpS dev.mysql.com

Local instance MySQL click! Create a new schema in the connected server click! default

show databases; use 인사급여; show tables; select * from 사원; select count(*), count(퇴사일자) from 사원; ## 직급별 인원수 select 직급, count(*) as 인원수 from 사원 group by 직급; ## 직급별 인원 및 평균 월급 select 직급,count(*) as 인원수, avg(월급여) from 사원 group by 직급; ## 급여 구분에 따른 평균 월급 select 급여구분, count(*), avg(월급여) from 사원 group by 급여구분; ## 입사 년도별 평균 월급 select year(입사일자) as 입사년도, count(*) as 인원수, avg(월급여) as 평균월급 from 사원 group by y..

group by 사용 후 조건을 추가 할 때 사용 (where과 비슷)