Today

강의

MySQL 데이터베이스 한번에 끝내기 SQL Full Tutorial Course using MySQL Database (42:23)

스터디 내용

• SQL 실습 강좌 복습
• SQLD 노란책 2과목 50번까지 풀이

결과

select countrycode, max(population) from city group by CountryCode
having max(Population) > 8000000;

select countrycode, name, sum(population) from city 
group by CountryCode,
name with rollup;

select * from city join country on city.countrycode = country.Code;

select * from city join country on 
city.countrycode = country.Code
join countrylanguage on city.CountryCode = countrylanguage.CountryCode;


select length('fqdsafd');
select concat('my', 'sql db', 'end couo');
select locate('abc', '123123243abc');
select left ('mysql is my open source',5);
select right ('mysql is my open source',5);
select lower('asdfpqewjisdf');
select upper('dsfqhldsf');
select replace('mssql', 'ms', 'my');
select trim('             asdf   '),
trim(leading '#' from '####mssms##'),
trim(trailing '#' from '####mssms##');

select trim(trailing '%' from 'sdfdasf%%');

select format(1231231.123123 , 6);

select floor(10.95)
,ceil(10.95), round(10.95);

Tomorrow

• SQLD 2과목 풀이
• 실습 복습

Summary

• 그냥 sqld 시험 전까진 이렇게 생활해야겠다.