Getting started:
Related tutorials:
- MySQL-CLI: https://www.youtube.com/playlist?list=PLfdtiltiRHWEw4-kRrh1ZZy_3OcQxTn7P
- Analyzing Business Metrics: https://www.codecademy.com/learn/sql-analyzing-business-metrics
Jayesh Agrawal JayeshAgrawal
🏠
JayeshAgrawal
/ GoodHabitMySQL.sql
Last active
January 19, 2021 16:24
Important aspect while work with MySQL to improve performance & troubleshoot
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /**** | |
| 1. Do not use stored procedure & function parameters name same as WHERE clause field name | |
| It will be responding with all record of query because MySQL interprets field value as parameter value similar like 1=1. | |
| Example: | |
| ****/ | |
| -- Bad | |
| CREATE PROCEDURE `getPersonById`(IN id INT(10)) | |
| BEGIN | |
| -- return all record instead |
JayeshAgrawal
/ README.md
Created
June 23, 2017 06:45
— forked from hofmannsven/README.md
My simply MySQL Command Line Cheatsheet