PHP/MySQL ->
Create and populate MySQL table

Syntax for creating table "Employees":

CREATE TABLE `Employees`
(
  `EmpNo` int(11) default NULL,
  `DeptNo` int(11) default NULL,
  `FirstName` varchar(20) default NULL,
  `LastName` varchar(30) default NULL,
  `Gender` varchar(1) default NULL,
  `City` varchar(50) default NULL,
  `Street` varchar(50) default NULL,
  `HouseNum` varchar(50) default NULL,
  `DateOfBirth` datetime default NULL,
  `ManagerNo` int(11) default NULL,
  `Salary` Float default NULL,
  UNIQUE KEY `empno_uniq_indx` (`EmpNo`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;


Insert sample data:
INSERT INTO Employees (EmpNo,DeptNo,FirstName,LastName, Gender,City,Street,HouseNum,DateOfBirth,ManagerNo,Salary)
VALUES (1, 1, 'john', 'silver', 'M', 'london', 'ukitgam', '780/19', '1958-12-08', NULL, 210000);

INSERT INTO Employees (EmpNo,DeptNo,FirstName,LastName, Gender,City,Street,HouseNum,DateOfBirth,ManagerNo,Salary)
VALUES (2, 1, 'gret', 'garbo ', 'F', 'berlin', 'akstrass', '102', '1949-01-15', 1, 65000);

INSERT INTO Employees (EmpNo,DeptNo,FirstName,LastName, Gender,City,Street,HouseNum,DateOfBirth,ManagerNo,Salary)
VALUES (3, 2, 'lee', 'chen ', 'M', 'berlin', 'oppenhaim', NULL,'1969-10-01', 2, 80000);

INSERT INTO Employees (EmpNo,DeptNo,FirstName,LastName, Gender,City,Street,HouseNum,DateOfBirth,ManagerNo,Salary)
VALUES (4, 3, 'daniel', 'defo ', 'M', 'rome', 'corso vinchi', '25', '1978-04-01', 5, 70500);


sqlexamples.info