All resources and articles on MySQL. Learn about MySQL’s relational database management system, covering installation, configuration, optimization, and security to effectively manage your data.
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 …
In this tutorial, we will explore the use of the MySQL CREATE TABLE command with syntax and programming examples: CREATE TABLE statement is a part of DDL (Data Definition Language) of SQL. We will discuss the ways in which you can CREATE a table in a given database, mention column …
Learn about different MySQL Data Types i.e. Numeric, String, Date data type, JSON, Boolean, etc. with examples: In this tutorial, we will learn about different data types that are supported by MySQL. Data types are specified against each column when a table is created and also while updating/altering the table …
Learn about different MySQL JOIN statements like Inner, Outer, Cross, Left, Right, And Self with syntax and programming examples: In this tutorial, we will learn about MySQL JOIN and also understand the different types of Joins that are supported in MySQL. JOIN in its simplest form can be thought of …
This MySQL Create View Tutorial Explains all about Creating a View in MySQL using Different Clauses & Examples. It also covers how to Drop & Manage Views: In MySQL, view is a virtual table that enables us to have a look at the data in the table without blocking the …
This Comprehensive Oracle Database Tutorial Explains What is a Database, Architecture, Oracle Tools & Features. Also includes Database Installation Process: In the previous tutorial of Oracle MySQL of Complete ORACLE Series, we have learned about the benefits & features like Data Security, High Availability & Cloud Service. Oracle database is one of …