[MySQL] SELECT, UPDATE, DELETE 기본 명령문

완전 기초적인건데, 안 써버릇 하니깐 가끔 까먹기도 하는 MySQL 기본 명령문

1. SELECT

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

ex) SELECT * FROM tbl_userinfo WEHRE height > 180 ;

ex) SELECT username FROM tbl_userinfo WHERE height < 180 ;

2. UPDATE

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

ex) UPDATE tbl_userinfo SET height = 180 WHERE height > 179.5 ;

3. DELETE

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

ex) DELETE FROM tbl_userinfo WHERE height < 100 ;