要不创建一个视图?CREATE VIEW view_records AS
SELECT room_id,send_id,recevie_id FROM room_records WHERE send_id LIKE '%-%'
UNION ALL
SELECT room_id,recevie_id,send_id FROM room_records WHERE recevie_id LIKE '%-%'";SELECT * FROM view_records
SELECT room_id,send_id,recevie_id FROM room_records WHERE send_id LIKE '%-%'
UNION ALL
SELECT room_id,recevie_id,send_id FROM room_records WHERE recevie_id LIKE '%-%'";SELECT * FROM view_records
$query = "SELECT * FROM temp_records";
你都不加限制条件,为什么要建临时表?
SELECT cm.*,tr.* FROM c_members cm LEFT JOIN
(SELECT COUNT(DISTINCT room_id) ctotal,COUNT(DISTINCT recevie_id) service,COUNT(send_id) count,send_id
FROM temp_records GROUP BY send_id)tr ON cm.id=tr.send_id
这个的作用是: 查出c_members表中所有的人来,并得到这个人在几个房间聊过天,跟几个人聊过天,总共聊了几句话我写这个查询语句实在不能一次查出来,我就想到了搞临时表以前写mysql4下的语句,现在mysql5增加了很多功能,我都是一步一步试的,肯定有很多不合理的地方