MySql的临时表以及不在存储过程中待变量的简单使用，很实用哦

1：原来MySql也可以有临时表，这点还是不错，

DROP temporary TABLE if EXISTS mytempdatatable;CREATE TEMPORARY table mytempdatatableSELECT tu.unit_session_uid,us.unit_session_sdate,us.unit_session_edate FROM unit tuINNER JOIN unit_session us ON tu.uni_id=us.uni_id AND us.unit_session_type=\'1\'WHERE tu.uni_id=\'47891229-62f4-4ab8-a95c-904e6dc037c0\' AND tu.isdel=0 and us.isdel=0 LIMIT 1;SELECT * FROM mytempdatatable;

View Code

2：不过执行之后，还可以单独使用到，也没有删除，这点和Sqlserver有些不一样

3：来一个带变量的操作，这个感觉还是很不错的，嘻嘻，越来越觉得mysql可爱了

DROP temporary TABLE  if EXISTS mytempdatatable;CREATE TEMPORARY table mytempdatatableSELECT tu.unit_session_uid,us.unit_session_sdate,us.unit_session_edate FROM unit tuINNER JOIN unit_session us ON tu.uni_id=us.uni_id AND us.unit_session_type=\'1\'WHERE tu.uni_id=\'47891229-62f4-4ab8-a95c-904e6dc037c0\' AND tu.isdel=0  and us.isdel=0 LIMIT 1;SET @sd=\'1990-01-01\',@ed=\'1990-01-01\';-- SELECT * FROM mytempdatatable;SET @sd=(SELECT unit_session_sdate FROM mytempdatatable);SET @ed=(SELECT unit_session_edate FROM mytempdatatable);SELECT @sd,@ed;