Database - DML (Data Manipulation Language) - insert - delete - update ๐ŸŽ๐Ÿฅญ

ํ™”์ดํ‹ฐ ยท2024๋…„ 1์›” 2์ผ
DatabaseINSERTdeleteoracleupdate
0

Database

๋ชฉ๋ก ๋ณด๊ธฐ
8/8

DML : ๋ฐ์ดํ„ฐ ์กฐ์ž‘์–ด
ํ…Œ์ด๋ธ”์— ์›ํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ์ž…๋ ฅ/์ˆ˜์ •/์‚ญ์ œํ•˜๋Š” ์—ญํ• 

  • insert : ๋ฐ์ดํ„ฐ ์ถ”๊ฐ€
  • delete : ๋ฐ์ดํ„ฐ ์‚ญ์ œ
  • update : ๋ฐ์ดํ„ฐ ์ˆ˜์ •

1. INSERT

INSERT INTO ํ…Œ์ด๋ธ”๋ช… (COLUMN LIST) VALUES (COLUMNS LIST)








2. DELETE



3. UPDATE



profile
ํ™”์ดํ‹ฐ
์—ด์‹ฌํžˆ ๊ณต๋ถ€ํ•ฉ์‹œ๋‹ค! The best is yet to come! ๐Ÿ’œ
์ด์ „ ํฌ์ŠคํŠธ

Database - DCL (Data Control Language) - GRANT, REVOKE, ROLE ๐ŸŒ

0๊ฐœ์˜ ๋Œ“๊ธ€