查询所有员工的入职天数,并根据入职天数倒序排序。
select name,datediff(curdate(), entrydate) as 'entrydays' from emp order by entrydays desc;
获取当前时间:
update emp set hiredate = NOW()
去掉字符串左或右边的空格(trim去除两边,rtrim去除右边):
update emp set ename = LTRIM(ename);
查询所有员工的入职天数,并根据入职天数倒序排序。
select name,datediff(curdate(), entrydate) as 'entrydays' from emp order by entrydays desc;
获取当前时间:
update emp set hiredate = NOW()
去掉字符串左或右边的空格(trim去除两边,rtrim去除右边):
update emp set ename = LTRIM(ename);