Most Useful SQL Commands List with Examples
SQL or Structured Query Language is a standard language used to to create, list, update, delete databases, tables, records. It
Continue reading
Category: Database
SQL “Select Into” Statement Usage Tutorial
SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle,
Continue reading
How To Create New User and Set, Grant Permissions To User In MySQL and MariaDB?
MySQL provides ability to create and users from its shell. Security is important part of the database servers. In this
Continue reading How To Check and Determine MySQL Database Server Version?
MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the
Continue reading How To List MySQL Tables with “show tables” SQL Query
MySQL stores given relation data in tables. While using tables we generally need to check and list existing tables. We
Continue reading How To Install MySQL On Ubuntu, Debian, Mint Kali
MySQL is free and opensource database server which is very popular in opensource community. MySQL is used by alot of
Continue reading
“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock'” Error and Solution
MySQL service provides different connection methods. We generally prefer TCP/IP way where connection is established over Network Socket. There is
Continue reading
What Is MySQL Default Port Number?
MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify
Continue reading
How To Define, Add, Create User For Postgres or PostgreSQL Server?
PostgreSQL Database Server have a lot of tools to manage the suite. Creating user is one of the most popular
Continue reading
How To Install PostgreSQL Server Into Linux, Debian, Ubuntu, CentOS, Mint, Fedora, Redhat?
PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be
Continue reading
