SQL 문법 정리 - DML, DDL, DCL,TCL, QUERY, 연산자
SQL 문법 정리 - DML, DDL, DCL,TCL, QUERY, 연산자 DML : INSERT, UPDATE, DELETE, SELECT DDL : CREATE, ALTER, DROP, TRUNCATE, RENAME DCL : GRANT, REVOKE TCL : COMMIT, ROLLBACK, SAVEPOINT DML ; Data Manipulation Language INSERT ~ INTO UPDATE ~ SET ~ WHERE DELETE ~ FROM ~ WHERE SELECT (*) FROM - SELECT문 순서 SELECT FROM WHERE GROUP BY HAVING ORDER BY (ASC/ DESC) DDL ; Data Definition Language CREATE ALTER DRO..
2023. 3. 18.
