mysql
hgtjcxy
这个作者很懒,什么都没留下…
展开
-
mysql删除重复元素并保留最小的标号
delete from person where Id not in(select min(id)from (select *from person)c group by c.email) andid in(select id from(select *from person)g where id in (select h.id from (select *from person)h,(se...原创 2018-08-22 19:37:39 · 192 阅读 · 0 评论 -
mysql日期date类型数据比较大小
write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.+---------+------------------+------------------+| Id(INT) | RecordDate(DATE) | Tempera...原创 2018-08-23 16:00:59 · 25733 阅读 · 1 评论 -
mysql中update 按条件进行更新
update salary set sex=case when sex='f' then 'm' else 'f' end;原创 2018-08-23 16:35:18 · 45978 阅读 · 1 评论 -
mysql 对一张表按某一列降序排列,并且对重复元素合并,输出的列名进行更改为目标值,若输出为“”,则输出null
先贴代码select ifnull((select distinct salary from Employee order by salary desc limit 1,1 ),null) as SecondHighestSalary ;这句话的意思是,执行ifnull中的expr1;若执行成功,则返回expr1的值;若执行失败,则返回null;(注意这里的null不能是'nul...原创 2018-08-20 20:38:40 · 876 阅读 · 0 评论 -
mysql中为同一张表取多个别名&为某一列取别名
select employee1.name as employee from employee employee1,employee employee2 where employee1.managerId=employee2.id and employee1.salary>employee2.salary;这里给同一张表取别名的方...原创 2018-08-20 21:31:48 · 10633 阅读 · 0 评论 -
Table configuration with catalog null, schema null, and table user did not resolve to any tables
在我想配置idea中Spring+Mybatis框架搭建 https://blog.csdn.net/kaka3511/article/details/78508782#commentsedit的时候,出现了以上问题,后来发现,是调用的数据库的表不同于是我就在下图位置改了表名,即可 ...原创 2018-09-04 19:10:40 · 20303 阅读 · 2 评论