Ubiq BI

How to Remove Default Value of Column in MySQL

Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL

If you request long URLs, Apache may give 414 request URI too large error. Here is how to fix 414 request URI too large in Apache.

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

Here is How to fix NGINX worker connections are not enough error for your website.

Sometimes you may need to restrict access to URL by IP. Here is how to restrict access to URL by IP.

Sometimes you may need to change a table name in MySQL. Here is how to rename table in MySQL.

PostgreSQL allows you to compare arrays using operators. Here is how to compare arrays in PostgreSQL.

Sometimes you may need to run multiple MySQL server on single machine. Here is how to run multiple MySQL instances on same machine.

Sometimes you may need to disable ETag header from server response. Here is how to disable ETag in NGINX server.