MySQL

How-tos Difference Between Two Tables in MySQL In today's post, we'll learn about finding the difference between two tables in MySQL. ↗ How-tos MySQL Stored Procedure With Parameters This tutorial demonstrates how to create MySQL stored procedure with parameters. ↗ How-tos MySQL Workbench: Edit Read-Only Table Data This 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 … ↗ How-tos Solutions to the Deprecated Mysql_connect in PHP This article will teach solutions to the deprecated mysql_connect in PHP. These solutions include mysqli_connect (procedural and OOP) and PHP Data Objects (PDO). ↗ How-tos Differences Between SQL and MySQL This 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 … ↗ How-tos MySQL ForEach Loop This tutorial educates about how we can simulate foreach loop in MySQL. ↗ How-tos The Equivalent of Oracle's decode Function in MySQL This tutorial educates about the equivalent of Oracle's decode function in MySQL using IF, CASE, and a combination of FIELD and ELT. ↗ How-tos Introduction to the MySQL Composite Key This tutorial is about an introduction to the MySQL composite key. It educates about its types, importance, and the ways to create it. ↗ How-tos MySQL Tinytext This article introduces how to use different datatypes in MySQL. ↗ How-tos DATETIME vs TIMESTAMP in MySQL This 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. ↗ How-tos MySQL Function This article introduces how to use and create a simple function in MySQL. ↗ How-tos Tiny Integer in MySQL This tutorial helps us understand about the concept of tiny integer in a MySQL database. ↗ How-tos The Datepart Function Alternatives in MySQL This tutorial illustrates alternative methods to the general SQL datepart function for extracting parts of a datetime in MySQL. ↗ How-tos Safe Mode in MySQL This tutorial helps us understand about the safe mode in a MySQL database. ↗ How-tos Nested Select Statements in MySQL for Enhanced Query This 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. ↗ How-tos Multiple Primary Keys in MySQL This tutorial demonstrates how to create multiple primary keys in a MySQL database. ↗ How-tos Isnumeric in MySQL This tutorial check if a value is numeric or not in a MySQL database. ↗ How-tos Greater Than Date in MySQL This tutorial demonstrates how to fetch values in a table greater than a specified date in a MySQL database. ↗ How-tos The Rank Function in MySQL This tutorial demonstrates the use of rank function in a MySQL database. ↗ How-tos Unsigned in MySQL This tutorial demonstrates what unsigned mean and how to use it in a MySQL database. ↗ How-tos Common Table Expressions in MySQL This tutorial demonstrates how to use common table expressions in MySQL. ↗ How-tos MySQL Cascade Delete This article introduces on delete cascade in MySQL ↗ How-tos The IF Statement in MySQL This tutorial demonstrates how to utilize the IF statement in MySQL database. ↗ How-tos The CASE Statement in MySQL This guide demonstrates the ways to use the CASE statement in MySQL database. ↗