[MsSql] SELECT, UPDATE, DELETE 명령문

MsSql 기본 명령문

sample_table
id	name	age
1	홍길동	14
2	강감찬	15
3	이순신	18

 

1. SELECT

   SELECT [컬럼명] FROM [테이블명] WHERE [조건절]

   EX) SELECT * FROM sample_table where age > 15 ;

   EX) SELECT name FROM sample_table where id = '1' ;

 

2. UPDATE

   UPDATE [테이블] SET [컬럼] = [값] WHERE [조건]

   EX) UPDATE sample_table SET age = 20 where age = 14 ;

 

3. DELETE

   DELETE FROM [테이블] WHERE [조건]

   EX) DELETE FROM sample_table WHERE age >14 ;