yangliuhbhd的博客

select unix_timestamp(date)-unix_timestamp(end) as '两者相差的秒数' from '表名'； 格式数据 CAST((statusTime.end_time-statusTime.create_time)as SIGNED)   两日期/时间之间相差的天数：     SELECT  To_Days(end_time) - To_Day...

   String sql="  SELECT  w.work_id, w.room_id,rm.name,CAST(sec_to_time(sum(unix_timestamp(statusTime.end_time)-unix_timestamp(statusTime.create_time))) as CHAR  )as times"+                   ",w.num...

mysql新建用户和赋予权限   2010-07-17 16:01:01|  分类： mysql |  标签： |字号大中小 订阅 //登录MYSQL @>mysql -u root -p @>密码 //创建用户 insert into mysql.user(host,user,password) values ("localhost","hbchen",passwor...