每日MySQL学习

insert into good_cates(name) select cate_name from goods group by cate_name;    将查询结果插入到good_cates表中, 可以完成表的复制操作

create table .. select 列名 .. 表示创建表并向表插入数据

https://www.cnblogs.com/myseries/p/10821372.html  SQL注入

https://blog.csdn.net/taifei/article/details/88641602  添加外键几种方式

https://www.cnblogs.com/zxf100/p/6812269.html 级联删除和更新

https://www.cnblogs.com/coolhtm/p/3942287.html 回滚点

https://www.cnblogs.com/zhizhao/p/7825469.html  drop、truncate和delete的区别

https://blog.csdn.net/liuqun0319/article/details/90409372  客户端模拟脏读 幻读和可重复读

https://blog.csdn.net/qq_27825451/article/details/81326165 内联结、自然联结、自联结、交叉联结

https://blog.csdn.net/u014204541/article/details/79739980  左连接、右连接、内连接、全连接笔记

https://blog.csdn.net/qq_33326449/article/details/53079082  UNION和UNION AII

https://www.cnblogs.com/Soprano/p/10659101.html  子查询总结

https://www.cnblogs.com/SunshineKimi/p/13800036.html  数据库外键关系分类

https://www.cnblogs.com/friday69/p/9389720.html  GROUP BY详解

https://www.cnblogs.com/niyl/p/9650183.html  多字段分组

https://www.cnblogs.com/shenjianping/p/13709213.html  数据库引擎

https://blog.csdn.net/wangfeijiu/article/details/113409719  索引详解

https://blog.csdn.net/eternal_yangyun/article/details/101037977	行锁和表锁

https://www.cnblogs.com/liliuguang/p/11015964.html		数据库优化

https://www.cnblogs.com/mm962464/p/14963401.html		索引失效的的几种方式