CREATE TABLE emp_table (
    emp_no   INT,
    emp_name VARCHAR(50),
    salary   INT
);

--登録
INSERT INTO emp_table VALUES(1, '井上', 20000);
INSERT INTO emp_table VALUES(2, '田中', 50000);

-- 検索
SELECT * FROM emp_table;
SELECT * FROM emp_table; WHERE emp_no = 1; 

--更新
UPDATE emp_table SET salary = 100;
SELECT * FROM emp_table;

--削除
DELETE FROM emp_table;
SELECT * FROM emp_table;