Menu

Practical solutions

MySQL Howtos How-To Guides

Solve the problem. Keep building. Collection of MySQL how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

MySQL StringHow to Search Rows to Find Substrings in MySQLWe will learn how to search rows to find substrings in MySQL using wildcard and LOCATE() function.

MySQL IntersectIntersect Operator in MySQLYou will learn about INTERESCT operator in MySQL and its emulation in various ways.

MySQL Escape SequencesHow to Escape Sequences in MySQLYou will learn about escape sequence characters in MySQL. You will also see how you can use escape sequences with wild card characters to find a pattern.

MySQL JoinHow to Delete With Join in MySQLThis tutorial demonstrates how to use JOIN in MySQL to delete items in a table.

MySQL QueryWhere vs Having in MySQLThis tutorial educates about the where clause and the having clause individually and the differences between them using code examples.

MySQL ColumnHow to Use the ORDER BY Clause With Multiple Columns in MySQLThis tutorial educates about the use of the order by clause with multiple columns in MySQL.

MySQL KeyHow to Drop Foreign Key in MySQLThis article introduces how to drop MySQL foreign key.

MySQL DateTimeHow to Get the Current Date and Time in MySQLThis tutorial demonstrates how to get the current date and time in MySQL and compares the NOW(), CURRENT_TIMESTAMP(), and SYSDATE() functions.

MySQL TableHow to Optimize Tables and Databases in MySQLThis tutorial demonstrates how to optimize tables and databases in MySQL using Windows and Ubuntu operating systems.

MySQL LikeHow to Enforce Like Case Sensitive in MySQLThis article introduces how to enforce like keyword to be case sensitive in MySQL.

PHP MySQLHow to Describe Database Table With Mysqli_query in PHPThis article teaches you how to describe a database table using mysqli_query. We'll describe the table using the SQL DESCRIBE command. The result in the browser will look like what you'll see in the MySQL console.

MySQL TableHow to Drop Constraint From the MySQL TableThis article introduces how drop constraints from the MySQL table.

MySQL Group ByMySQL Group by With Count FunctionThis quick article discusses the use of group by clause in conjunction with count function in MySQL.

MySQL RestoreHow to Restore Database From SQL File in MySQLThis tutorial demonstrates how to restore the database from sql file in MySQL.

MySQL PermissionHow to Create Read-Only User in MySQLThis article mainly discusses how to create the read-only user in MySQL. You need to make a user who can only access a database in read-only mode. The database's data can be seen or read by the user, but neither the data nor the database's structure can be altered by the user.

MySQL BackupHow to Backup a Single Table Using MysqldumpThis article discusses using mysqldump to back up a single table in MySQL using the cmd.

MySQL SynchronizationHow to Synchronize MySQL DatabaseThe aim of this article is to demonstrate how to achieve database synchronization for backup and record-keeping purposes.

MySQL PasswordHow to Store Password in MySQL DatabaseIn this guide, you'll be able to learn how to store hash password in MySQL database, the different techniques and their specific methods used for storing the Hash password.

MySQL RecursiveMySQL Recursive QueryIn this guide, we will learn about the recursive query in MySQL.

MySQL QueryHow to Select All Tables in MySQLThis tutorial demonstrates how to select all the tables in a MySQL database.

MySQL TableHow to SELECT From Multiple Tables in MySQLThis article demonstrates how to SELECT from multiple tables in SQL and have it unique per row

MySQLHow to Store Arrays in MySQLThis article demonstrates how to store arrays in MySQL.

MySQLHow to Insert a Row if Not Exists in MySQLThis article demonstrates how to insert a row into a table if it doesn't exist yet in mySQL

MySQL ImportHow to Import a CSV File Into a Table in a MySQL DatabaseThere are two ways to import data from a comma-separated values file into a MySQL database. The first method is to do it programmatically with SQL commands, and the other is using an interactive MySQL client such as HeidiSQL.