OneCompiler

sql query for creating , inserting and fetching data from table

417

-- create
CREATE TABLE EMPLOYEE (
empId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name TEXT NOT NULL,
dept TEXT NOT NULL
);

-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accounting');
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales');
INSERT INTO EMPLOYEE VALUES (0004, 'Avan', 'MR');

-- fetch
SELECT * FROM EMPLOYEE WHERE dept = 'MR';