SQL Tutorial part-10 MySQL DATE TIME Difference
Query from the DATETIME field in the database to find out the difference / distance between two datimes is...
SQL Tutorial part :9 How to view time zone and open connection of MY...
Timezone of MySQL Server
We know how timezones are viewed and set in PHP. I also...
SQL Tutorial part :8 SQL Conditional query and Advanced SQL
Conditional queries can be made with SQL. Just like if..else, CASE..WHEN is used in programming languages, you can also...
SQL Tutorial part :7 Why and how to do ALIAS in SQL table and...
Alias is used for the convenience of queries. Elias can be used in both table and column. Alias can...
SQL Tutorial part :6 WHERE IN
In the previous tutorial, we will bring the data using the WHERE .. IN clause in the "users" table....
SQL Tutorial part :4 LIMIT Clause
The LIMIT statement is used in conjunction with the SELECT statement. A table in a database can have thousands...
SQL Tutorial part :5 – Primary Key
The primary function of the primary key is to identify each row of a table individually