MySQL
金大大诶
用抽象构建架构,用实现扩展细节。
展开
-
MySQL数据库学习
建表学生表create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10))DEFAULT charset = utf8;insert into Student values('01' , '赵雷' , '1990-01-01' , '男')insert into Student...原创 2019-02-16 11:45:31 · 764 阅读 · 0 评论 -
数据库插入信息时报字符错误的问题
1. 建表时设置默认字符串编码方式为utf8 create table test() default charset = utf8;2. 已经添加的表需要设置一下: alter table test convert to character set utf8 collate utf8_unicode_ci;3. 直接修改数据库的字符串编码...原创 2019-03-05 10:17:40 · 516 阅读 · 0 评论 -
[LeetCode]Second Highest Salary-limit offset介绍
在员工工资表中返回第二高的记录,如果没有则返回null。使用limit offsetSELECT (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1) AS SecondHighestS...原创 2019-03-03 14:55:38 · 161 阅读 · 0 评论 -
LeetCode-Duplicate Emails
select Email from( select Email, count(Email) as num from Person group by Email) as statisticwhere num > 1;group by 和 havingselect Emailfrom Persongroup by Emailhaving count(Emai...原创 2019-03-03 15:39:08 · 207 阅读 · 0 评论