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 ->
Category: MySQL-MariaDB
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
Pay attention when using MySQL User-Defined Variables
Recently, i used a user-defined variable to store some values, and it showed an unexpected result. I updated rows using ‘where a
How to get the network packets between MySQL client and server?
Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we
What you should know before changing MySQL max_connections variable
Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This
Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL
Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace
MySQL Schema comparison between PROD and UAT/DEV Servers
Hello Folks, Today I’ll be writing an article on how to do schema comparison of MySQL database between 2