SQL injections are included in the OWASP Top 10. Over the past 20 years in view of the widespread nature the Internet has become, almost all Web applications now have their own databases to store important data. Web application security is primarily affected by the SQL injection vulnerability, which lets an attacker see and perhaps change data stored in a database. We give an in-depth explanation of the various SQL injection attack techniques in this paper. The goal of this study is to make SQL injection and SQL injection assaults more understandable. The different kinds of SQL injection attacks and their effects are categorized, explained, and shown. The examination of the SQL injection detection and prevention approach is reviewed and summarized at the end of the study. Additionally, we provide future approaches and potential advancements for SQL injection problem countermeasures.