Mysql
1、时间差(秒级别)
select creatime,updatime,TIMESTAMPDIFF(MICROSECOND,creatime,updatime)/1000000 AS time_diff from 表名 where application like '%17%' and creatime>"2024-06-14 14:41:29.803" and client_id in("LSW12345678901223") order by creatime desc;
说明:计算出creatime和updatime的时间差(秒级别),差值取名为time_diff ,where后面都是附加查询条件
2、查看表字段注释信息
SHOW FULL COLUMNS FROM 表名;
3、其他sql语句
表相关字段: