MySQL Archives - Page 3 of 14

How to Run SQL Script in MySQL

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 remove primary key or remove key constraint from MySQL table. Here is how to remove primary key in MySQL.

Sometimes you may need to find most frequent column value in MySQL. Here are the steps to do so.

Often you may need to truncate foreign key constrained table in MySQL. Here are the steps to do so.

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.