8000 Comparing freedream520:master...bestravis:master · freedream520/MySQL · GitHub
[go: up one dir, main page]
Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: freedream520/MySQL
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: master
Choose a base ref
...
head repository: bestravis/MySQL
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: master
Choose a head ref
Checking mergeability… Don’t worry, you can still create the pull request.
  • 17 commits
  • 41 files changed
  • 4 contributors

Commits on Jul 4, 2016

  1. distinct 和 order by 一起使用时，order by 后的字段必须要出现在 select 后面

    佛奴 authored and 佛奴 committed Jul 4, 2016
    Configuration menu
    Copy the full SHA
    025a6c1 View commit details
    Browse the repository at this point in the history

Commits on Jul 20, 2016

  1. exist 适用于 外表小、内表大，in 适用于 外表大、内表小，in 不走索引，所以一般情况下 exist 的效率高于 in。

    fonu committed Jul 20, 2016
    Configuration menu
    Copy the full SHA
    5d58913 View commit details
    Browse the repository at this point in the history

Commits on Dec 19, 2016

  1. left join 是 left outer join 的简写

    @fonu
    fonu committed Dec 19, 2016
    Configuration menu
    Copy the full SHA
    df1bcf3 View commit details
    Browse the repository at this point in the history

Commits on Dec 30, 2016

  1. mysql 中文排序

    @fonu
    fonu committed Dec 30, 2016
    Configuration menu
    Copy the full SHA
    e0c3cd7 View commit details
    Browse the repository at this point in the history

Commits on Mar 10, 2017

  1. mysql 多列索引

    @fonu
    fonu committed Mar 10, 2017
    Configuration menu
    Copy the full SHA
    9888ef1 View commit details
    Browse the repository at this point in the history

Commits on Mar 14, 2017

  1. 无符号的数字类型 unsigned

    @fonu
    fonu committed Mar 14, 2017
    Configuration menu
    Copy the full SHA
    5b400c3 View commit details
    Browse the repository at this point in the history

Commits on Apr 18, 2017

  1. MySQL 存储引擎 

    1.MyISAM
不支持事物，不支持外键，但是访问速度快。

2.InnoDB
支持事物，但是处理效率差一些，占用更多的磁盘空间以保留数据和索引。
    @fonu
    fonu committed Apr 18, 2017
    Configuration menu
    Copy the full SHA
    a7c22dc View commit details
    Browse the repository at this point in the history

Commits on Jun 5, 2017

  1. mysql 多列索引

    @fonu
    fonu committed Jun 5, 2017
    Configuration menu
    Copy the full SHA
    36379c1 View commit details
    Browse the repository at this point in the history

Commits on Jul 28, 2017

  1. 整理

    @fonu
    fonu committed Jul 28, 2017
    Configuration menu
    Copy the full SHA
    6a764f1 View commit details
    Browse the repository at this point in the history

Commits on Aug 15, 2017

  1. SQL执行顺序，从右向左

    @fonu
    fonu committed Aug 15, 2017
    Configuration menu
    Copy the full SHA
    b142721 View commit details
    Browse the repository at this point in the history

  2. 组合索引：从前向后依次使用生效，如果中间某个索引没有使用，那么断点前面的索引起作用，断点后面的索引不会起。用。

    @fonu
    fonu committed Aug 15, 2017
    Configuration menu
    Copy the full SHA
    bcea7e8 View commit details
    Browse the repository at this point in the history

Commits on Aug 21, 2017

  1. mysql 表锁&行锁

    @fonu
    fonu committed Aug 21, 2017
    Configuration menu
    Copy the full SHA
    7ebdfc6 View commit details
    Browse the repository at this point in the history

Commits on Sep 4, 2017

  1. mysql主键索引与非主键索引

    @fonu
    fonu committed Sep 4, 2017
    Configuration menu
    Copy the full SHA
    3a080c8 View commit details
    Browse the repository at this point in the history

  2. ....

    @fonu
    fonu committed Sep 4, 2017
    Configuration menu
    Copy the full SHA
    d20d77e View commit details
    Browse the repository at this point in the history

Commits on Sep 5, 2017

  1. explain 查看SQL执行情况

    @fonu
    fonu committed Sep 5, 2017
    Configuration menu
    Copy the full SHA
    74f213f View commit details
    Browse the repository at this point in the history

Commits on Dec 4, 2017

  1. insert into ... select ...

    岳东鹏 committed Dec 4, 2017
    Configuration menu
    Copy the full SHA
    3c1470a View commit details
    Browse the repository at this point in the history

Commits on Jan 10, 2018

  1. MySQL 的 delete 语句不要只指定表别名，否则报错。

    岳东鹏 committed Jan 10, 2018
    Configuration menu
    Copy the full SHA
    ed07716 View commit details
    Browse the repository at this point in the history
Loading
0