Sometimes you may need to fetch data from multiple databases in a single query. Here is how to make cross database queries in MySQL.
How to make cross database queries in MySQL
MySQL
How to Copy/Transfer Data from One Database to Another in MySQL
Sometimes you may need to copy/transfer data from one database to another in MySQL. Here are the steps to do it.
How to Check MySQL Version in Ubuntu
Access denied for user ‘root’@’localhost’ (using password: NO Ubuntu)
How to Concatenate Strings in MySQL
Sometimes you may want to concatenate strings or multiple columns in MySQL. Here is how to concatenate strings in MySQL.
How to Find Non-ASCII Characters in MySQL
How to Use Reserved Word as Column Name in MySQL
Sometimes you may need to use reserved word as column name or table name in MySQL queries. Here is how to use reserved word in MySQL.
How to pass parameter in MySQL query
How to Disable Strict Mode in MySQL
Strict mode in MySQL controls how invalid or missing values are handled in INSERT, UPDATE & CREATE TABLE queries. Here is how to disable strict mode in MySQL.
MySQL Row Number Function & Its Uses
MySQl Row Number is a very useful window function in MySQL. Here is MySQL Row Number Function & its applications.