Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.
How to Concatenate Multiple MySQL Rows into One Field
MySQL
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).
How to MySQLDump Only Specific Tables
Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.
Difference Between InnoDB vs MyISAM
Single quotes, Double quotes and Backticks in MySQL
MySQL supports using single quotes, double quotes and backticks. Here is when to use single quotes, double quotes and backticks in MySQL.
Inner join vs Outer join in SQL
Inner join and outer join are useful to join database tables in SQL. Here is the difference between inner join and outer join in SQL.