SELECT a.id_ AS id ,a.vehicleid_ AS vehicleid ,(SELECT b.name_ FROM Vehicle_ b WHERE b.id_=a.vehicleid_) AS vehiclename ,a.alarmtype_ AS alarmtype ,FROM_UNIXTIME(a.time_,'%Y-%m-%d %H:%i:%s') AS time FROM Alarm_ a WHERE 1=1 上面的语句是什么意思?
我觉得是从Alarm_ 这个表查出一些信息,字段分别是id_,a.vehicleid_ ,(SELECT b.name_ FROM Vehicle_ b WHERE b.id_=a.vehicleid_) 这是个结果集,alarmtype_,和FROM_UNIXTIME函数的结果吧,WHERE 1=1是hql语句的写法吧,不管什么条件都满足吧