직원 테이블 EMPLOYEE 샘플

직원 테이블 EMPLOYEE 샘플

1 예시

CREATE TABLE employee (
  `id` int(11) NOT NULL,
  `name` varchar(16) NOT NULL,
  `department_id` int(11) NOT NULL,
  `birth_date` date NOT NULL,
  PRIMARY KEY (`id`)
) CHARSET=utf8;

INSERT INTO employee (id, name, department_id, birth_date) VALUES
(1, '한놈', 1, '1999-01-01'),
(2, '두시기', 2, '2000-01-01'),
(3, '석삼', 2, '1999-01-01'),
(4, '너구리', 3, '2000-01-01');

2 PHP

$rows = array(
	array('id'=>1, 'name'=>'한놈', 'depratment_id'=>1, 'birth_date'=>'1999-01-01'),
	array('id'=>2, 'name'=>'두시기', 'depratment_id'=>2, 'birth_date'=>'2000-01-01'),
	array('id'=>3, 'name'=>'석삼', 'depratment_id'=>2, 'birth_date'=>'1999-01-01'),
	array('id'=>4, 'name'=>'너구리', 'depratment_id'=>3, 'birth_date'=>'2000-01-01'),
);

3 같이 보기

• 부서 테이블 DEPARTMENT 샘플
• 직원 테이블 EMPLOYEE
• MySQL 뷰 생성 CREATE VIEW