It is important for developers and administrators to learn MySQL. Here are the best 5 online resources to learn MySQL.
Top 5 Online Courses to Learn MySQL
MySQL
MySQL Select Top N Rows Per Group
Often database developers need to select top n rows per group in a table. Here are different ways to get top rows per group in MySQL.
How to Enable Remote Access in MySQL
Often database administrators need to allow remote users to access database. Here is how to enable remote access in MySQL.
How to Create Read Only MySQL User
Often database administrators need to create read only users for MySQL. Here are the steps to give read only user access in MySQL.
How to Increase Max Connections in MySQL
Sometimes database administrators need to increase max connections in MySQL. Here are the steps to do it.
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.