![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
文章平均质量分 82
fainionchen
这个作者很懒,什么都没留下…
展开
-
Leetcode之mysql专题《Trips and Users》
题目内容如下(链接:https://leetcode.com/problems/trips-and-users/description/):The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are both foreign keys to the User...原创 2018-10-13 20:39:09 · 179 阅读 · 0 评论 -
Leetcode之mysql专题《Department Top Three Salaries》
题目内容如下(链接:https://leetcode.com/problems/department-top-three-salaries/description/):The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id...原创 2018-10-13 23:10:03 · 122 阅读 · 0 评论 -
Leetcode之mysql专题《Human Traffic of Stadium》
题目内容如下(链接:https://leetcode.com/problems/human-traffic-of-stadium/submissions/1)X city built a new stadium, each day many people visit it and the stats are saved as these columns: id, date, peopleP...原创 2018-10-14 00:00:58 · 126 阅读 · 0 评论 -
mysql数据表迁移编码问题
在工作中,经常需要对旧机器裁撤,如果机器上有数据表则必须进行迁移。在迁移过程中,数据表编码是个很烦人的问题,最近就遇到这种问题,这里记录下解决过程,方便以后查阅。1. 先看看新旧机器的数据库编码:show variables like 'character%'旧机器(latin1)新机器(utf8) 2. 再看看要迁移的数据表的编码ENGINE=MyISAM A...原创 2019-02-16 17:16:02 · 461 阅读 · 0 评论