Programming | Mediumpedia

SQL Tutorial part-10 MySQL DATE TIME Difference

ByAmidur RahmanSeptember 3, 2020

Query from the DATETIME field in the database to find out the difference / distance between two datimes is very easy and there are many methods. For example, the table in this tutorial will show you how to find different types of queries with different types of queries. If

SQL Tutorial part :9 How to view time zone and open connection of MY SQL Server

ByAzar SammieSeptember 3, 2020

Timezone of MySQL Server We know how timezones are viewed and set in PHP. I also know that the timezone can be changed if desired. E.g. It’s easy. But many times it is necessary to look at the timezone of MySQL server. It is often seen that the date of your application

SQL Tutorial part :8 SQL Conditional query and Advanced SQL

ByAzar SammieSeptember 1, 2020

Conditional queries can be made with SQL. Just like if..else, CASE..WHEN is used in programming languages, you can also filter data while retrieving data in SQL. You can do this filtering using CASE .. WHEN etc. If we want to make such a query from the two tables (users and

SQL Tutorial part :7 Why and how to do ALIAS in SQL table and field

ByAzar SammieSeptember 1, 2020

Alias is used for the convenience of queries. Elias can be used in both table and column. Alias can be called as nickname or nickname. If we use the query used in Left Join Elias then it will be like below ** It is a good practice to put a table name with a dot […]

SQL Tutorial part :6 WHERE IN

ByAzar SammieAugust 31, 2020

In the previous tutorial, we will bring the data using the WHERE .. IN clause in the “users” table. Suppose I need users between the ages of 33, 25, and 26, then type the following query and run it. Output Or suppose I just want to see the payroll and email of

SQL Tutorial part :4 LIMIT Clause

ByAzar SammieAugust 31, 2020

The LIMIT statement is used in conjunction with the SELECT statement. A table in a database can have thousands of rows. If you want to see a few rows from here, then you need LIMIT. With LIMIT you can see a few rows from the middle or some rows from the first side or some

SQL Tutorial part :5 – Primary Key

ByAmidur RahmanAugust 30, 2020

The primary function of the primary key is to identify each row of a table individually 1. With this, each entries of the table are uniquely identified. 2. You can set one or more columns as the primary key. Whatever you do, this primary key tie will mark each row of your