
Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL
Sometimes you may need to convert lowercase to uppercase or uppercase to lowercase. Here is how to convert case of string in PostgreSQL
You can easily concatenate columns & strings in PostgreSQL. Here is how to concatenate strings in PostgreSQL.
MySQL allows you to remove NOT NULL constraint in MySQL. Here is how to remove NOT NULL constraint in MySQL.
Redshift does not allow you to drop not null constraint for columns. Here is how to remove Not Null Constraint in Redshift
Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL
Sometimes you need to round timestamp to hour, minute, day, seconds, month. Here is how to round timestamp in MySQL
Sometimes you may need to change values of multiple columns in PostgreSQL. Here is how to update multiple columns in PostgreSQL
PostgreSQL allows you to compare arrays using operators. Here is how to compare arrays in PostgreSQL.