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 QuerySubstring in MySQLThis guide will show the use of the substring of a particular column in MySQL. MySQL ConditionIf ELSE in MySQLThis tutorial demonstrates how to use IF ELSE statement in MySQL. MySQL ElasticSearchElastic Search in MySQLWe will learn how to integrate ElasticSearch with MySQL. We will also examine a few key differences between JSON format databases and relational databases. MySQL TableDifference Between Two Tables in MySQLIn today's post, we'll learn about finding the difference between two tables in MySQL. MySQL Stored ProcedureMySQL Stored Procedure With ParametersThis tutorial demonstrates how to create MySQL stored procedure with parameters. MySQL WorkbenchMySQL Workbench: Edit Read-Only Table DataThis article will teach you how to edit read-only table data in MySQL Workbench. First, we'll create the read-only table, and then we'll show you how to edit it. We'll do all these using MySQL 8.0.29 and MySQL Workbench 8.0 Community Edition (CE). MySQL ConnectionSolutions to the Deprecated Mysql_connect in PHPThis article will teach solutions to the deprecated mysql_connect in PHP. These solutions include mysqli_connect (procedural and OOP) and PHP Data Objects (PDO). MySQL SQLDifferences Between SQL and MySQLThis article explains five differences between SQL and MySQL. Our explanations will include both code and words, so you'll have a clear understanding on the differences between SQL and MySQL. MySQL LoopMySQL ForEach LoopThis tutorial educates about how we can simulate foreach loop in MySQL. MySQL DecodeThe Equivalent of Oracle's decode Function in MySQLThis tutorial educates about the equivalent of Oracle's decode function in MySQL using IF, CASE, and a combination of FIELD and ELT. MySQL Composite KeyIntroduction to the MySQL Composite KeyThis tutorial is about an introduction to the MySQL composite key. It educates about its types, importance, and the ways to create it. MySQL TinytextMySQL TinytextThis article introduces how to use different datatypes in MySQL. MySQL DATETIMEDATETIME vs TIMESTAMP in MySQLThis tutorial will introduce you to DATETIME and TIMESTAMP data types. You will also understand where to use them and what are their similarities and differences. MySQL FunctionMySQL FunctionThis article introduces how to use and create a simple function in MySQL. MySQL QueryTiny Integer in MySQLThis tutorial helps us understand about the concept of tiny integer in a MySQL database. MySQL DatepartThe Datepart Function Alternatives in MySQLThis tutorial illustrates alternative methods to the general SQL datepart function for extracting parts of a datetime in MySQL. MySQL ModeSafe Mode in MySQLThis tutorial helps us understand about the safe mode in a MySQL database. MySQL SelectNested Select Statements in MySQL for Enhanced QueryThis tutorial introduces the concept of nested select statements for advanced querying in MySQL. A few included examples also illustrate possible use-cases of this concept. MySQL KeyMultiple Primary Keys in MySQLThis tutorial demonstrates how to create multiple primary keys in a MySQL database. MySQL QueryIsnumeric in MySQLThis tutorial check if a value is numeric or not in a MySQL database. MySQL QueryGreater Than Date in MySQLThis tutorial demonstrates how to fetch values in a table greater than a specified date in a MySQL database. MySQL FunctionThe Rank Function in MySQLThis tutorial demonstrates the use of rank function in a MySQL database. MySQL UnsignedUnsigned in MySQLThis tutorial demonstrates what unsigned mean and how to use it in a MySQL database. MySQL QueryCommon Table Expressions in MySQLThis tutorial demonstrates how to use common table expressions in MySQL.