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: MySQL
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 Connect MySQL Database From Python Application and Execute Sql Query with Examples
MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we
Continue reading
Mysql Database Import Tutorial with Examples
Backup and Restore operations are important part of the database administration. mysqlimport command is used to load data in file
Continue reading
