Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Last updated: May 23, 2022

Miscellaneous

With the name, it covers all the topics that are miscellaneous yet important to cover and are part of Mysql. Such topics are how to add comments in MySQL. Not everywhere we can use Hash and c-comments. Other such topics are check constraint, storage engine and how to export and import the database or import the CSV file into the database or export a table to CSV, Universal Unique Identifier (UUID), lead and lag functions, and Common Table Expression (CTE)
MySQL Comments
In this article, we will discuss comments in MySQL. We will also see their types, benefits, and how you can put comments with your SQL statements in MySQL.
SQL - CHECK Constraint
This blog introduces the CHECK constraint in SQL with various examples to understand how to use CHECK constraint with columns or on ALTER TABLE.
MySQL Storage Engine
This blog will understand various storage engines or table types MySQL uses. Read the blog to learn more.
MySQL Export and Import Database
The article discusses the import and export of databases in MySQL and the ways to do that by command-line tool and MySQL workbench.
MySQL Import CSV file in the database
In this session, we are going to learn how we can import a CSV file into a MySQL database using the command live client and MySQL workbench.
MySQL Export Table to CSV
In this blog, you will find various detailed approaches to export a MySql table to a CSV file.
MySQL LEAD and LAG Function
This blog incorporates MySQL LEAD and LAG functions along with their syntaxes and examples.
MYSQL CTE EASY
In this session, we are going to learn about MySql CTE, recursive CTE, and we will talk about how to use MySql CTE in multiple tables with examples.
MySQL GROUP_CONCAT() function HARD
The MySQL group_concat function is an aggregate function. Aggregate functions are functions that are performed on a group of values - and return a single value.
ON DELETE CASCADE in MySql MEDIUM
In this article, we will learn about On Delete Cascade in MySql. To know more, you can check the complete article.
Author Tisha
0 upvotes
Rename Database in MySQL EASY
This article covers the steps needed to rename a Database in MySQL along with codes, outputs and images showing the queries and commands used.
RLIKE Operator in MySQL MEDIUM
In this article, we will learn about the RLIKE operator in MySQL. We’ll also cover the difference between LIKE and RLIKE and examples.
Author Shiva
0 upvotes
SQL Clauses MEDIUM
This article gives a detailed overview of the SQL Clauses, followed by their types along with examples.
Author Komal
0 upvotes
Constraints in SQL Server MEDIUM
This blog will discuss constraints in SQL servers. We will discuss NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, DEFAULT, and CHECK constraints.