MySQL-MariaDB

In Mysql servers, the following methods can be used to find where the error log file is. Find where the Error Log is with SELECT …

In MySQL NDB Cluster databases, when the data memory is full, “The table is full” error occurs in all operations in the tables. To resolve …

You can use the below functions to convert the timestamp to date and date to timestamp. timestamp to date -> from_unixtime() date to timestamp -> …

To check connected users in MySQL database and what operations are performed, we can use mysql cli or we can obtain same information through queries. …

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

Here is my favorite handy query to get the list of tables in MySQL without Primary Key : [crayon-673f97a8800c8200158989/] This my shortest article ever, hope …

Description: As we know, we can’t create a function-based index on MySQL, not like PostgreSQL (https://www.postgresql.org/docs/current/indexes-expressional.html). Usually, we should avoid using functions in the where …

  Recently, i used a user-defined variable to store some values, and it showed an unexpected result. I updated rows using ‘where a in (@var)’, but this query …

  Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the …

  Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This means that the number of …