As stated in the previous post, a synonym in databases is an alternative name or alias for a table, view, sequence, or other schema items.
AWS RDS – Cannot modify a default parameter group error
For details about AWS RDS Parameter groups, please click here. Sometimes, when we try to modify the value of a dynamic variable in the Parameter
Parameter Group in RDS
The engine configuration settings that are applied to one or more DB instances are contained in DB parameter groups. Only Multi-AZ DB clusters are covered
Get part of the string from a string in MySQL
We may occasionally need to search within a string for a certain text. Multiple built-in functions provided by MySQL made the task simple. To extract
IF Condition in MySQL
A condition is verified using the MySQL IF() function. If the condition is TRUE, the IF() function returns a value, and if the condition is
Multiple ways to display the list of databases in MySQL
The list of databases is frequently viewed by developers and DBAs. There are alternative methods for seeing the databases depending on whether you want to
Big Data & SQL 