SQLize | PHPize | SQLtest

-- Create EMP Table CREATE TABLE EMP ( EMPNO INT(6), ENAME VARCHAR(20) NOT NULL, JOB VARCHAR(20) NOT NULL, MGR INT(3), SAL DECIMAL(7,2), DEPTNO INT(2) ); -- Create DEPT Table CREATE TABLE DEPT ( DEPTNO INT(2) PRIMARY KEY, DNAME VARCHAR(10), LOC VARCHAR(10) ); -- Add COMMISSION Column to EMP Table ALTER TABLE EMP ADD COMMISSION DECIMAL(10,2); -- Modify JOB Column in EMP Table ALTER TABLE EMP MODIFY JOB VARCHAR(20); -- Add Foreign Key Constraint to EMP Table ALTER TABLE EMP ADD CONSTRAINT FK_EMP_DEPT FOREIGN KEY (DEPTNO) REFERENCES DEPT(DEPTNO); -- Add Check Constraint to EMP Table ALTER TABLE EMP ADD CONSTRAINT CHK_EMPNO CHECK (EMPNO > 10); -- Modify SAL Column to Add Default Value ALTER TABLE EMP CHANGE SAL SAL DECIMAL(7,2) DEFAULT 5000; -- Add DOB Column to EMP Table ALTER TABLE EMP ADD DOB DATE; -- Add DOJ Column to EMP Table ALTER TABLE EMP ADD DOJ DATE; -- Drop DOJ Column from EMP Table ALTER TABLE EMP DROP COLUMN DOJ; -- Create EMP1 Table Based on EMP Structure CREATE TABLE EMP1 AS SELECT * FROM EMP WHERE 1=0; -- Insert Data into EMP1 Table INSERT INTO EMP1 (EMPNO, ENAME, JOB) VALUES (101, 'JOHN DOE', 'MANAGER'); -- Truncate EMP1 Table TRUNCATE TABLE EMP1; -- Drop EMP1 Table DROP TABLE EMP1;