LOCK TABLES in MYSQL
The article contains information about LOCK TABLES in MySQL VTY system. Features added to the database during database design or
Category: MySQL-MariaDB
MySQL Temporary Tables
The article contains information about the MySQL Temporary Tables used to create a temporary table in MySQL VTY system. What
How do I declare a variable in MySQL?
The article contains information about declaring variable in MySQL VTY system to store temporary data. Variables can be used to
Where is MySQL Error Log File
In Mysql servers, the following methods can be used to find where the error log file is. Find where the
The table ‘X’ is full error in MySQL
In MySQL NDB Cluster databases, when the data memory is full, “The table is full” error occurs in all operations
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 ->
How To List Connected Users in MySQL
To find out who is connected to the mysql database and what operations are performed, we can use mysql cli
How To Reset MySQL root Password
The MySQL root password allows the root user full access to the MySQL database. If you do not remember the
Handy Query : List of MySQL Tables Without Primary Key
Here is my favorite handy query to get the list of tables in MySQL without Primary Key :
|
1 2 3 4 5 6 |
USE INFORMATION_SCHEMA; SELECT TABLES.table_schema, TABLES.table_name FROM TABLES LEFT JOIN KEY_COLUMN_USAGE AS c ON ( TABLES.TABLE_NAME = c.TABLE_NAME AND c.CONSTRAINT_SCHEMA = TABLES.TABLE_SCHEMA AND c.constraint_name = 'PRIMARY') WHERE TABLES.table_schema not in ('information_schema','performance_schema','mysql') AND TABLES.table_type = 'BASE TABLE' AND c.constraint_name IS NULL; |
This
Optimizing MySQL queries where clause contains function by using Generated Columns
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