SQL Subqueries Examples
In this article I want to help you and anyone who has doubts about how subqueries work with various simple and very graphic examples that clear up doubts. Content Example…
MySQL DATE_SUB
If you are working with date type columns you need to know the DATE_SUB function. Do you know her? Yeah? Here I leave you a bit of everything, this is…
MySQL CURDATE SQL function
Looking for examples of CURDATE? If you have doubts about how to use the CURDATE function in MySQL or you want an example of copy and paste this post is…
NOW() function in SQL: Definition, syntax and practical examples in Select, Update and Insert queries
Welcome to srcodigofuente.com! In this tutorial I will teach you everything you need to know about the SQL NOW function. This function is very useful for working with dates and…
SQL operators
In this SQL tutorial/class I am going to explain to you operators in SQL. Operations to set conditions or perform calculations on any SQL query. In addition, since it could…
How to use the BETWEEN command in SQL
Hello! In this tutorial we are going to talk about the SQL BETWEEN command, a very useful operator for searching a range of values. If you are a web developer…
SQL text searches
Text searches are essential functionality in SQL and MySQL, allowing users to find specific information within a database. These searches can be simple or advanced, depending on the user's needs.…
SQL MATCH AGAINST operator for text
Hello! In this tutorial I am going to talk about the MATCH AGAINST command or operator. This SQL operator will allow you to perform more advanced searches in your databases.…
REGEXP in SQL
I imagine that if you are reading these lines you already know the regular expressions in SQL. If so, in this article I am going to show you how to…
Avoid sql injection in PHP with PDO class
If we develop complex web applications, or at least with a constant use of database queries, we must be concerned about the security of our information, and therefore ensure the…