mysql 临时表操作

已有表order

根据已有的表创建临时表

CREATE TEMPORARY TABLE tmp_table SELECT * FROM order;

直接创建临时表

CREATE TEMPORARY TABLE tmp_table (  
      name VARCHAR(10) NOT NULL,   
      time date  NOT NULL  
  )

更高级点就是

create temporary  TABLE `temtable` (  
  `jws` varchar(100) character set utf8 collate utf8_bin NOT NULL,  
  `tzlb` varchar(100) character set utf8 collate utf8_bin NOT NULL,  
  `uptime` date NOT NULL  
) ENGINE=InnoDB DEFAULT CHARSET=latin1″