cxc576502021的专栏

题目内容如下（链接：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...

题目内容如下（链接：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...

题目内容如下（链接：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, people P...

在工作中，经常需要对旧机器裁撤，如果机器上有数据表则必须进行迁移。在迁移过程中，数据表编码是个很烦人的问题，最近就遇到这种问题，这里记录下解决过程，方便以后查阅。 1. 先看看新旧机器的数据库编码： show variables like 'character%' 旧机器(latin1) 新机器(utf8)   2. 再看看要迁移的数据表的编码 ENGINE=MyISAM A...