Sometimes database administrators need to increase max connections in MySQL. Here are the steps to do it.
How to Increase Max Connections in MySQL
MySQL
How to Unpivot Table in MySQL
Sometimes MySQL developers need to unpivot table in MySQL. Here are the steps to unpivot MySQL database table.
How To Alter Column From NULL to NOT NULL
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
How to Import SQL File in MySQL
Sometimes database administrators need to import sql file in MySQL. Here are the different ways to do it.
How to Concatenate Multiple MySQL Rows into One Field
Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.
How to See Foreign Keys Related to Table or Column
Do you need to get list of foreign keys related to table or column in SQL? Here are the different ways to get foreign keys referencing table in MySQL.
How to Reset Auto Increment in MySQL
Sometimes database developers need to reset auto increment column in MySQL. Here are different ways to set the auto increment value.
How to List Users in MySQL
Database administrators need to determine the users in MySQL server. Here is how to list users in MySQL.
How to Get Character Set of MySQL database or table or column
Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.
How to Prevent SQL Injection Attack
It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).