MySQL Archives - Page 2 of 8

How to Select Rows Where Date Matches Day in MySQL

Sometimes you may need to select rows where date matches day in MySQL. Here are the steps to do it.

Sometimes you may need to execute SQL files in MySQL. Here is how to run SQL script in MySQL.

Sometimes you may need to find number of columns in MySQL table. Here is how to find number of columns in table in MySQL.

Sometimes you may need to search a specific text in every field of database in MySQL. Here is how to do this.

Often you may need to remove leading & trailing whitespace from strings in MySQL. Here are the steps to do it.

Sometimes you may need to export MySQL schema without data. In this article, we will learn how to do this.

Sometimes you may need to check MySQL engine type for table. Here are the steps to do so.

Sometimes you may need to use LIKE operator in SQL for multiple values. Here are the steps to do it.

Sometimes you may need to add column after another column in MySQL. Here is how to do this.

Sometimes you may need to retrieve MySQL username and password if you have lost it. Here are the steps to do so.