CreateDept_Table1.htm
  • Windows 10 MySQL
Creating Dept Table

CREATE TABLE dept(
DEPTNO mediumint(2) NOT NULL,
DNAME char(14) DEFAULT NULL, LOC char(13) DEFAULT NULL,
PRIMARY KEY (DEPTNO)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Dept Created

Create PHP Script "

$sql = "CREATE TABLE dept(\n"
    . "DEPTNO mediumint(2) NOT NULL,\n"
    . "DNAME char(14) DEFAULT NULL, LOC char(13) DEFAULT NULL,\n"
    . "PRIMARY KEY (DEPTNO)\n"
    . ") ENGINE=InnoDB DEFAULT CHARSET=utf8";
 
INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');
INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');
INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');

Using PHP