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…
LIKE SQL Operator Guide with Examples
You probably already know that SQL SELECT queries are very powerful, and allow you to perform practically any data selection imaginable, especially when you have a mastery of them. In…
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…
Concatenate in SQL
If you are looking to learn sql concatie concatenate sql results or columns, texts, or values in general to get a string from the array, you are looking for the…
Learn SQL JOIN now
Forward! With this tutorial I want you to learn clearly and directly the SQL JOIN clause. Since there is not a single way to do a JOIN And since I…
Update SQL Example
If you are here, you are surely looking to remember the syntax of the SQL Update statement or to see quick and practical examples that will help you with your…
alter in SQL
SQL allows the structure of a table to be altered in any way a developer needs. For all these queries we use the ALTER statement. Alter SQL can basically be…
DROP SQL with examples
Content SQL DROP TABLE Syntax Use cases sample querySQL DROP TABLE The DROP TABLE command in SQL allows you to permanently drop a table from a database. This removes at…
What is SQL?
Content SQL Definition What is SQL used for? The advantages of SQL Disadvantages The main SQL statementsSQL definition Let's get very academic for once and start with the definition of…