Database Tutorials

How to convert timestamp to datetime and datetime to timestamp in MySQL

You can use the below functions to convert the timestamp to date and date to timestamp. timestamp to date ->

In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table

To find out who is connected to the mysql database and what operations are performed, we can use mysql cli

The MySQL root password allows the root user full access to the MySQL database. If you do not remember the

Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that

Once MongoDB is installed, by default, authentication is not enabled, users can login without specifying user name / password. Authorization

In my previous articles, I talked about MongoDB Community Edition installation and MongoDB Sharded Cluster components in general. You can

As you know security is one of the key points during database administration. In MongoDB sharded clusters security between components

MongoDb Sharding is a method used to distribute data to multiple machines. Sharding improves data access performance. if you want

This article describes how to install MongoDB Community Edition on CentOS Linux. The same installation applies to RedHat Linux versions.