how can id assign foreign key mysqli

问题:

I have created at 2 tables. These tables are Department, employee.

Now i want to assign foreign key in department table and join with employee table.

have any idea??

SELECT id,department FROM department; 
SELECT * FROM `employee'

回答1:

create employee table field are- id(primary key),name,dept_id
department table fields are-dept_id(primary key),name

after select the dept_id.give index.

than select the department table and dept_id.than click save button.

回答2:

Are you looking for this:-

$query="select emp.name, dep.department from employee emp 
INNER JOIN 
department dep ON 
emp.department=dep.department 
order by emp.name asc";