Nodejs、Typescript、Express、Koa、MySQL、Egg、Nest、Redis、Mongodb.zip

# Mysql 学习 ## Docs ### mysql * [MySQL入门教程（MySQL tutorial book）](https://github.com/jaywcjlove/mysql-tutorial) * [MySQL的my.ini配置]([https://github.com/jaywcjlove/mysql-tutorial/blob/master/chapter2/2.5.md](https://www.cnblogs.com/zhoading/p/15260978.html)) * [mysql命令](https://juejin.im/post/5ae55861f265da0ba062ec71) * [MySQL数据类型](https://github.com/jaywcjlove/handbook/blob/master/MySQL/MySQL%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B.md) * [MYSQL数据库设计规范与原则](https://bbs.aliyun.com/read/534385.html?spm=a2c4e.11155515.0.0.14401fd24VGZ9R) * [mysql的基本使用](https://www.w3schools.com/nodejs/nodejs_mysql.asp) * [MySQL之char、varchar和text的设计](https://www.cnblogs.com/billyxp/p/3548540.html) * [Node 连接 MySQL](https://www.jianshu.com/p/cfa013bbcabb) * [windows下mysql初始密码设置](https://blog.csdn.net/Jiang_Rong_Tao/article/details/52102217) * [一对一，一对多，多对多](https://blog.csdn.net/qi1840439776/article/details/78233398) * [MySQL · 最佳实践 · 分区表基本类型](http://mysql.taobao.org/monthly/2017/11/09/) * [MySql表分区——partition](https://segmentfault.com/a/1190000009724052) * [常见电商项目的数据库表设计（MySQL版）](https://www.jianshu.com/p/b89127a415df) * [mysql中函数CONCAT及GROUP_CONCAT的使用](https://segmentfault.com/a/1190000004844113) * [图解MySQL 内连接、外连接、左连接、右连接、全连接](https://blog.csdn.net/plg17/article/details/78758593) * [SQL 中left join、right join、inner join的区别](https://www.jianshu.com/p/e7e6ce1200a4) * [MySQL - exists与in及any的用法](https://blog.csdn.net/J080624/article/details/72910548) * [MySQL查询语句中的IN 和Exists 对比分析](https://blog.51cto.com/andrewli/2120928) * [select case when if 的一些用法](https://www.cnblogs.com/martinzhang/p/3220595.html) * [mysql中find_in_set()函数的使用](https://www.cnblogs.com/xiaoxi/p/5889486.html) * [Mysql之IN 和 Exists 用法](https://www.cnblogs.com/zhangminghui/p/4403672.html) * [mysql触发器案例分析以及before和after的区别](http://blog.itpub.net/29654823/viewspace-2153312/) * [MySQL连接字符串函数CONCAT，CONCAT_WS，GROUP_CONCAT使用总结](https://my.oschina.net/MiniBu/blog/478342) * [详细实例全面解析SQL存储过程](https://www.w3cschool.cn/sql/sql-storage.html) * [组合查询（Union）](https://segmentfault.com/a/1190000007926959) * [MySQL类型float double decimal的区别](https://www.cnblogs.com/gulibao/p/5416245.html) * [Update批量更新与批量更新多条记录的不同值实现方法](https://www.jianshu.com/p/f71c88aca6fc) ### sequelize * [Sequelize 中文API文档](https://demopark.github.io/sequelize-docs-Zh-CN/) * [Migrations - 迁移](https://demopark.github.io/sequelize-docs-Zh-CN/migrations.html) ## Code * [在node中使用mysql](Code/mysql-demo/app.js) ## Tutorial ### MySQL高级进阶视频教程 * [01 - mysql编码设定.md](Tutorial/MySQL高级进阶视频教程/01%20-%20mysql编码设定.md) * [02 - 会话变量和全局变量.md](Tutorial/MySQL高级进阶视频教程/02%20-%20会话变量和全局变量.md) * [03 - 存储过程.md](Tutorial/MySQL高级进阶视频教程/03%20-%20存储过程.md) * [04 - 流程控制语句.md](Tutorial/MySQL高级进阶视频教程/04%20-%20流程控制语句.md) * [05 - 函数的创建.md](Tutorial/MySQL高级进阶视频教程/05%20-%20函数的创建.md) * [06 - 视图的创建.md](Tutorial/MySQL高级进阶视频教程/06%20-%20视图的创建.md) * [07 - 触发器的应用.md](Tutorial/MySQL高级进阶视频教程/07%20-%20触发器的应用.md) * [08 - 锁机制.md](Tutorial/MySQL高级进阶视频教程/08%20-%20锁机制.md) * [09 - 事务.md](Tutorial/MySQL高级进阶视频教程/09%20-%20事务.md) * [10 - 慢查询.md](Tutorial/MySQL高级进阶视频教程/10%20-%20慢查询.md) * [11 - 索引.md](Tutorial/MySQL高级进阶视频教程/11%20-%20索引.md) * [12 - 表的优化.md](Tutorial/MySQL高级进阶视频教程/12%20-%20表的优化.md) * [13 - 表的分区.md](Tutorial/MySQL高级进阶视频教程/13%20-%20表的分区.md) * [14 - mysql的内存优化.md](Tutorial/MySQL高级进阶视频教程/14%20-%20mysql的内存优化.md) * [15 - mysql应用优化.md](Tutorial/MySQL高级进阶视频教程/15%20-%20mysql应用优化.md) * [16 - mysql的账号权限.md](Tutorial/MySQL高级进阶视频教程/15%20-%20mysql的账号权限.md) ### Mysql数据库的优化技术 * [01 - 关键技术.md](Tutorial/Mysql优化/01%20-%20关键技术.md) * [02 - 表的设计.md](Tutorial/Mysql优化/02%20-%20表的设计.md)