Concatenate strings in PHP
Joining texts in PHP is essential for any programmer and is therefore part of the basics of programming in this web programming language. Join texts or strings in programming is…
SQL Update records from one table to another
Has the need arisen for you to update records by crossing the information between tables? If so, you're in the right place; In this tutorial I am going to explain…
SQL INSERT MULTIPLE
Welcome to another tutorial on SQL INSERT queries for beginners, in this particular article I am going to explain how to perform SQL queries for multiple insertsthat is, make an…
SQL INSERT INTO SELECT
If you are here, you surely know how to perform an INSERT SQL without problems, at least in the simple and classic way, and you are wondering how to perform…
SQL INSERT DATE NOW
In this short article I show you how to insert the current date and time into MySQL. Specifically, we will see the 3 ways of get current date and time…
MAX SQL FUNCTION
In this tutorial I will explain how to calculate max and min in sql. To perform the queries I will use the SQL SELECT query in several examples. Also, I'm…
SQL UPDATE REPLACE
In this short article we will see how replace values with SQL. Specifically, and without going into details, I am going to explain how to perform UPDATEs that replace texts…
Books to learn SQL
When it comes to learning SQL, we often resort to searching Google, although it is true that most of us who do it already have knowledge of the language and…
SQL LIKE operator
Surely you already know that SQL SELECT queries are very powerful, and allow you to perform practically any unimaginable data selection, especially when you have a high command of all…
SQL subqueries
If you've already mastered SQL SELECT queries with WHERE, GROUP BY, or HAVING, the next thing to learn is SQL subqueries. Below you will find the tutorial divided into three…