sql – Page 2 – POFTUT

sql

How To Create a Database and Table In MySQL and MariaDB?

by
How To Create Database and Table In MySQL and MariaDB?

MySQL database is a very popular database server used by a lot of small and big companies. In this tutorial we will look at the basics of MySQL server like creating databases and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql … Read more

What is The Difference Between Inner and Outer Join?

by

Sql is the language where a lot of data can be get with different logic. In an enterprise environment we may need to use complex SQL queries to get meaningful data. Inner is one of the logic where we join two tables with different magic. Example Tables In order to understand Inner and Outer Joins … Read more