[MySQL] mysql 기본 명령 | Notion

문제 1.

데이터베이스 생성

https://lh6.googleusercontent.com/zuFcTOw5p-onQQwcrmHedq9C3lkS4Gf0z7Jxaho6dlko6NKb6xmgx7NKQ3JIabd4IXqZVG28TnPnv3cJ9yFbpN7jNnVMb6TxAUNfLngcV2K7v_OnjF-NbWQlf18IQAE3VfH_FCg

데이터베이스 whois가 잘 생성되었는지 SHOW databases로 확인.

테이블 생성

https://lh6.googleusercontent.com/mfU2kHIXDt-rrMmRzhS5LHCjgBSXjc19ey9x8LeXQWELEwtUCajuusDgVeEPM0jDfeLfw3W_seal-wUYegF2gpiQkRAZwCKtfWccCz0zrIxKLqb5eRPzSeMvbT7iqHMY8u0yESc

https://lh3.googleusercontent.com/qhrP5DJYOCIKBEjWWyP_R_2gHFIBo2kO24sN1XeaFYcycfRuYruWIXb8ZyizUh4vii9uKT4XGALtSab4cqMmFTJBB9IWvtk9ICUWNHdvb4dvTbUOjejdfQ3ud_txx_bODT36oQI

Primay key를 정해주지 않아, key를 num으로 설정하려 함.

https://lh6.googleusercontent.com/znW9yQi7WoSKWk_USkjnbYuGQI-lpUXQLKEgBgwcqYfOU5ykO5trKUrY9sf_tZepngrQqii4ALe9uDi4aGtc3Bk9dZNYCu6WMmJJIoavJi3Gt65L_jADipydPjEp5HbboH6VhvU

데이터 추가

첫 데이터 row를 생성하고 employee 테이블에 잘 들어갔는지 확인해보고, 이후에 나머지 데이터를 INSERT로 넣어준 후 확인해봤는데 잘 들어갔다.

https://lh5.googleusercontent.com/Xhw4pIvXQSO3ZkVimI8XWU5Dn6cZGrmnI-TyZlkxEkNMggRjc2A2uikezMA6jypIfsIJgFOBCEVWqRPMRgBuOZ5VzDY5Tr-txRTl8_LK2DCOpN8UsVt1E28mc8u2VQc2xpa4gXw

https://lh6.googleusercontent.com/Lx_1qKOhNTRqciaPgaGbXHZwh3DKKL3u7IE8FEqCYfaSabuSRQfYffkgpLi2jLvk7bL1sGjgkJjXGNYBZPFHDPep06wEidKF2MdERcF1Tcyc-1neP_aHbsqot2GDWDGwuo9b6yA

쿼리 수행

10개월 이상 일한 사원의 정보를 사원번호 오름차순 기준으로 나열

https://lh5.googleusercontent.com/hdrvYbl8PJoxo7LZHrffuPMQzQVD-9WEZ5_rQd6SPs_59-vPpY8W0xXxa4jJY0q-J-RHMtezlb0W7W18j-f-qIVAUvo7OQkS2TGtn7JgOcoHK5-r69m9PcdtNGeEfKz-ugOEUxc