Sometimes you may need to select rows where date matches day in MySQL. Here are the steps to do it.
MySQL
How to Run SQL Script in MySQL
How to Find Number of Columns in Table 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.
How to Search for Text in Every Field of Database in MySQL
Sometimes you may need to search a specific text in every field of database in MySQL. Here is how to do this.
How to Remove Leading & Trailing Whitespace from Column in MySQL
Often you may need to remove leading & trailing whitespace from strings in MySQL. Here are the steps to do it.
How to Export MySQL Schema Without Data
Sometimes you may need to export MySQL schema without data. In this article, we will learn how to do this.
How to Check MySQL Engine Type for Table
How to use LIKE operator in SQL for multiple values
Sometimes you may need to use LIKE operator in SQL for multiple values. Here are the steps to do it.
How to Add Column After Another Column in MySQL
How to Retrieve MySQL Username and Password
Sometimes you may need to retrieve MySQL username and password if you have lost it. Here are the steps to do so.