INSERT DELETE UPDATE

use BaseballData;

select*
from salaries
order by yearID DESC;

--INSERT INTO [TableName] 
--VALUES [Values]
INSERT INTO salaries
values(2020,'KOR', 'NL', 'rookie', 90000000);
--> 데이터 하나 빼먹으면 Error 발생
--> 
INSERT INTO salaries(yearID,teamID,playerID,lgID,salary)
valueS (2020,'KOR','rookiss','NL',19000000)

--DELETE FROM [TableName]
--where [조건] -> 조건을 붙이지 않으면 테이블이 날라간다.
DELETE FROM salaries
WHERE playerID = 'rookiss'

--UPDATE [TableName]
--set[열 = 값,]
--where [조건]
update salaries
set salary = salary*2, yearID = yearID *2
where teamID = 'KOR'