时间范围查询

select * from loginfo where eventtime between '2007-04-17' and '2007-04-19'

select * from loginfo where  eventtime>='2007' and eventtime<='2008'

 

 

select   *   into   B    
  from   A    
  truncate   table   B  
   
  这样就将整个表A的结构复制给了表B  
  但不包含表A的类容