In the previous article we were talking about INNER JOINS. Today we will try to understand OUTER JOINS with all their types.
If you want to understand how they work - this is place for you, just click Read more :)
Read moreIn the previous article we were talking about INNER JOINS. Today we will try to understand OUTER JOINS with all their types.
If you want to understand how they work - this is place for you, just click Read more :)
Read moreINNER JOIN is the simplest JOIN type and if you want to understand the clue of using JOINS,
you definitely should start from this point.
In this article i will show you how to use INNER JOIN and explain when to use it properly.
Read moreSometimes you want to change the column name to make it more readable and easier to analyze.
AS clause will fit all your expectations in this field
Read moreThis article will help you with understating GROUP BY and HAVING commands inside SQL language.
Read moreSQL is not a hard language, but the common usage of different ORM tools can make us less focused on clean SQL queries than ever.
This is why i wrote here a small cheatsheet with simple SQL commands.
Read moreCopying data from ssh to local is not that hard:
scp -r admin@servername.com:domains/domain-name.pl/public_html/admin/backups admin/backups
This is how to copy from local to remote:
scp /Downloads/example_file.txt admin@servername.com:domains/domain-name.pl/public_html/admin/backups
You can use "-r" flag to copy full folder. Without this you can copy only one file.