Home » Core Java » sql » Page 4

sql

SQL Delete Query Example

1. Introduction In this article, we will look at one of the Data Manipulation Language (DML) constructs or statements called SQL Delete query using the MySQL RDBMS. 2. What is Data Manipulation Language? In SQL, Data Manipulation language consists of sql data-change statements which modify data but not the underlying schema or database objects. The commands included in the data ...

Read More »

SQL Like – SQL Not Like

In this article, we will be exploring the SQL Like and the SQL Not Like operators. These operators help in filtering specific patterns from the columns. 1. About SQL Like & SQL Not Like Let us start with understanding what both these operators are. 1.1 What is SQL Like operator? The SQL Like operator is used to filter the data ...

Read More »

SQL Truncate Table Example

In this article, we are going to explain the SQL Truncate Table through examples. While using tables in databases, you may need to delete the data of the entire table. In this article, we will study the SQL Truncate Table command, and use it with an example. We will also understand the difference between the SQL Drop Table command and ...

Read More »

SQL Update Statement Example

This is an article of SQL using the Update statement. 1. Introduction In this article, we will look at one of the Data Manipulation Language (DML) constructs or statements called Update statement using the MySQL RDBMS. 2. What is Data Manipulation Language? In SQL, Data Manipulation language consists of SQL data-change statements which modify data but not the underlying schema ...

Read More »

SQL Drop Table Example

While using databases and tables, you may encounter a situation when you will have to drop the table – including the data, and the structure of the table. For this purpose, you will use the SQL Drop Table command. 1. Pre-requisities To implement the examples given in the article, you can use SQL in the following ways. Install MySQL in ...

Read More »

SQL Insert Query Example

1. Introduction In this article, we will look at one of the Data Manipulation Language (DML) constructs or statements called Insert query using the MySQL RDBMS. 2. What is Data Manipulation Language? In SQL, Data Manipulation language consists of sql data-change statements which modify data but not the underlying schema or database objects. The commands included in the data manipulation ...

Read More »

SQL Rename Database

In this article, we will explain how to rename a database using SQL. 1. Introduction In this article, we will look at one of the Data Definition Language or data description language (DDL) concepts called Rename the Database. We will see how we do this in the MySQL database. 1.1 What is Data definition language? In SQL, Data definition language ...

Read More »

SQL Create Table Example

This article focuses on the functionality and usage of the SQL Create Table command. A Relational Database Management System stores data in form of relations. A relation comprises of tuples and attributes. In layman terms, relation means a table comprising of rows and columns. A tuple is a row, whereas an attribute is a column. 1. Pre-requisites You can implement ...

Read More »

SQL SELECT Statement Example

1. Introduction In this article, we will look at one of the most used clauses used in SQL known as SELECT. 1.1 What is SQL? In 1974, Donald Chamberlin and Robert Boyce designed a programming language called SQL or “sequel”. It is based on relational algebra and tuple-relational calculus. So, this is the programming language for designing and maintaining a ...

Read More »

SQL Server Convert function Example

This example will explain the SQL Server Convert function with its syntax and a proper example. SQL Server is relational database management (RDBMS). Microsoft has developed the SQL Server. Many of the Database Management Systems use SQL, and SQL Server is not different. 1. Pre-requisites To run this example, you should have SQL Server downloaded and installed on your local ...

Read More »