All Database related articles and resources. Discover database design, management, optimization, and security to effectively store, retrieve, and protect your organization’s data assets.
Comprehensive comparison Of MariaDB vs MySQL based on various factors such as platforms supported, performance, syntax, popularity, etc: In today’s dynamic data world, there are a variety of databases and we can select the one that suits our requirements and we need the most. Therefore, it’s important to not just …
A detailed comparison between PostgreSQL vs MySQL based on parameters like performance, supported platforms, governance, security, etc: In this tutorial, we will discuss in detail the two major RDBMS systems: PostgreSQL and MySQL. These systems are widely preferred for the development of various types of applications. We will be covering …
Understand the main differences between MySQL and MongoDB through this in-depth review and comparison of MongoDB vs MySQL databases: In today’s world, both relational and nonrelational databases are being used depending upon the type of applications. Relational databases provide high levels of consistency and transaction guarantees while Document-based (or Nonrelational …
Learn about MySQL REPLACE() function and MySQL REPLACE INTO Statement with examples through this tutorial: MySQL provides 2 variants of REPLACE, one as a REPLACE String Function and another as a REPLACE Statement, which is like using an INSERT Statement. As the name suggests, the REPLACE function is used to …
This tutorial explains the step-by-step method to set up and use the MySQL Docker container with examples: Docker is a container orchestration platform that enables us to run an image of any application (in this case MySQL server) on a host system (which could behave in any OS installed – …
In this tutorial, we will learn about syntax and usage of MySQL SHOW DATABASES command with programming examples. We will also learn how to filter results using LIKE and WHERE clauses: This command is used to list down the databases available on a MySQL server. The command also provides options …
This tutorial explains the usage of MySQL IF and IF ELSE Statements in Select queries with syntax and practical programming examples: MySQL provides an IF() function which is a flow control function and depending on the condition specified and its evaluation to true or false, the rest of the statement …
Learn about the usages of various forms of the MySQL COUNT function with examples: COUNT is a simple aggregate function, yet very effective and widely used. In very simple words, it’s used to COUNT the number of rows against a given SELECT query and criteria. This tutorial will explain the …
Learn about MySQL GROUP BY command to group data of the table as per the different operations performed on the table with examples: The MySQL GROUP BY clause is used as an optional clause along with the SELECT command and is used to summarize the data in table rows. The …
This tutorial explains pattern matching using the MySQL LIKE operator: Pattern matching is an important feature in almost all programming languages like – Java/C#/Python etc which mostly leverage the usage of Regular Expressions for pattern matching against a given string input. MySQL provides an easy to use operator called LIKE, …
Learn about MySQL ALTER Table command to add/drop a column, index, constraint, change table name, etc. with examples: MySQL ALTER command is used to modify an existing table by adding a new column or removing an existing column or changing the data type of column. Simply speaking, the ALTER command …
Learn about MySQL SUBSTRING and SUBSTRING_INDEX functions and its usage with multiple examples: MySQL Substring function is used to extract a substring or part string against the input string. As the name suggests the Substring function operates on a string input and returns a smaller substring against the options specified. …
This tutorial explains the basics of MySQL FOREIGN KEY Constraint such as its syntax, how to add, declare, drop, and change it with examples: In very simple terms, the FOREIGN KEY is used to link two or more tables in MySQL. MySQL tables need to be connected in order to …
This tutorial explains the basics of the MySQL Transaction such as how to Start, Commit, and Rollback a transaction with simple examples: With databases, it is imminent that anyone learning afresh or a senior database person should know at least the basics of MySQL TRANSACTION. MySQL broadly means executing a …
This tutorial explains how to use MySQL CONCAT with Select and GROUP_CONCAT functions with syntax and practical examples: CONCAT is a String function supported by MySQL to combine or join two or more Strings together and return as a single value. The name CONCAT comes from the verb concatenation, which …
This tutorial explains the MySQL UNION command, its types, Union vs Union All, and examples to combine data from 2 or more queries: MySQL UNION is used to combine results from multiple SELECT queries into a single result set. It’s also possible to have all the complex queries/operations in the …
This tutorial explains the steps to Create a Database in MySQL with syntax and examples. Also includes how to delete a database with an example: In MySQL, to perform any of the operations, the primary necessity is of the availability of a database. A database holds various tables within it, …
This tutorial explains MySQL Create User command with different authorization mechanisms, password management, resource limit options, etc: MySQL CREATE USER command is used to create new users and grant granular access to databases/tables, etc. Multiple people use a MySQL server instance, having different access levels. For example, some users are …
This comprehensive tutorial provides syntax and examples of MySQL Date Format and Timestamp functions like current date, add date, add time etc.: In this tutorial, we will learn in-depth about the MySQL Date and Time data types and the various functions provided by MySQL for manipulating date and time values. …
Step by step guide to download MySQL for Windows and macOS using different methods: In this tutorial, we will learn the different ways/approaches to see how you can download MySQL and start using it within a couple of minutes. MySQL can be downloaded as a standalone installer for different operating …