SQL usage

sql

select * from Salaries limit 10;

select yearID from Salaries limit 20 order by salary;

create table mytable (id integer, name varchar(255), debut DATE);

insert into mytable (id, name, debut) values ('1','jeffrey',CURRENT_DATE);

update mytable set debut = '2010-09-01' where id=1

replace into mytable (id, name, debut);

insert or ignore into mytable;

-- delete, alter , drop

select * from mytable;

alter table mytable rename to helloworld;

alter table helloworld add column DOB date;

-- sql functions

select substr(playerID,1,8) from main.Managers;
select upper(playerID) from Managers;
select avg(length(playerID)) from Managers;

-- max, avg, count, sum

select count(playerID) from Managers;

-- 시간 관련된 function 들 다루기

select DATE('NOW');
select current_timestamp;
select date(current_timestamp);

select datetime(current_timestamp, '+1 day');