MySQL查询

SELECT d_id,d_name FROM bumen WHERE
d_name='人事部' OR d_name='科研部';

SELECT * FROM yuangong WHERE
d_id=141001 OR d_id=141002;

ALTER TABLE yuangong ADD FOREIGN KEY(d_id)
REFERENCES bumen(d_id);

ALTER TABLE worker ADD FOREIGN KEY(d_id)
REFERENCES department(d_id);

ALTER  TABLE  worker drop foreign key worker_ibfk_1;

DROP TABLE department;

SELECT  * FROM yuangong  limit 4, 2;

SELECT d_id ,d_name ,function FROM bumen;
SELECT d_id,d_name FROM bumen WHERE d_name="人事部" OR d_name="科研部";

SELECT * FROM yuangong WHERE birthday>=25 AND birthday<=30;


SELECT DISTINCT yuangong.d_id,COUNT(id) FROM
yuangong GROUP  by yuangong.d_id;

SELECT DISTINCT yuangong.d_id,COUNT(id),max(salary) FROM
yuangong GROUP  by yuangong.d_id;


SELECT * FROM bumen,yuangong WHERE bumen.d_id=yuangong.d_id;

SELECT DISTINCT yuangong.d_id,COUNT(id),sum(salary) FROM
yuangong group by yuangong.d_id;

SELECT * FROM yuangong ORDER BY salary desc;

SELECT name,birthday,address FROM yuangong WHERE
 address LIKE '北京市%';