22 lines
395 B
SQL
22 lines
395 B
SQL
CREATE TABLE emp_table (
|
||
emp_no INT,
|
||
emp_name VARCHAR(50),
|
||
salary INT
|
||
);
|
||
|
||
--“o˜^
|
||
INSERT INTO emp_table VALUES(1, 'ˆä<EFBFBD>ã', 20000);
|
||
INSERT INTO emp_table VALUES(2, '“c’†', 50000);
|
||
|
||
-- ŒŸ<C592>õ
|
||
SELECT * FROM emp_table;
|
||
SELECT * FROM emp_table; WHERE emp_no = 1;
|
||
|
||
--<2D>X<EFBFBD>V
|
||
UPDATE emp_table SET salary = 100;
|
||
SELECT * FROM emp_table;
|
||
|
||
--<2D>í<EFBFBD>œ
|
||
DELETE FROM emp_table;
|
||
SELECT * FROM emp_table;
|