In this tutorial, we’ll learn how to create a backup of any database using MySQLDumps and then we’ll recover the database. Introduction The backing up of a database is a crucial part of a Database Management System. As a database administrator, it is important to learn how to create a backup of databases. But the …
In this tutorial, we will learn about the EXISTS operator in MySQL. It is a handy operator while writing complex nested queries. We will understand the use of the EXISTS operator, and then we will see multiple examples of it with the SELECT, INSERT and DELETE statements. This is going to be an exciting tutorial …
You may have faced several situations where the same rows in a MySQL table are inserted twice or more. It is very important to ensure that no duplicate data resides in the table. So, in this tutorial, we are going to learn how to delete duplicate data from the table. Not only one but we …
Delete Duplicate Rows in MySQL (3 Simple Methods) Read More »
In this tutorial, we’ll learn how we can back up and restore a database or all the databases in MySQL using MySQL Workbench. Introduction While working with databases, we perform a lot of changes over a database. Sometimes we make huge mistakes like dropping a database or dropping a table. When we don’t keep backups …
Backup and Restore a MySQL Database Using MySQL Workbench Read More »
Comments are a very important part of any programming language. MySQL also provides us with the feature of comments. Like any other programming language, there are multiple types of comments available in MySQL. In this tutorial, we will learn what are the different types of comments in MySQL and how to use them with practical …
MySQL Comments – How To Add Comments To Your Queries Read More »
In this tutorial, we will learn how to add a new column to the table in an easy way. Along with it, we will see how we can add more than one column to the table and how to add a new column before or after a particular existing column. This is going to be …
In this tutorial, you’ll learn how to update a table from a java application using JDBC Driver. In SQL, an update statement refers to modifying existing records in a table. For example, You have an employee table, which has columns like name, department, and email. Also read: Insert Data into MySQL Database using JDBC There …
In this tutorial, We’ll learn how to create or drop a database in MySQL. Features of MySQL database: It is open-source software. It is a relational Database Management System(RDBMS) It has both the console as well as GUI(Graphical User Interface) It is a widely used RDBMS. It is useful for both small as well as …
Many times you may have faced the situation where you wanted to compare two tables and get unmatched records out of them. This is a common practice when database migration is done. So in this tutorial, we will learn how to compare two tables to find unmatched records. So, let’s get started! Prerequisites In MySQL, …
Compare Two Tables in MySQL – Find Records Without Matches Read More »
In this tutorial, we’ll learn how to insert data into a table in a MySQL database using JDBC. For this tutorial you must have: MySQL on your desktop/laptop. Download and Install: https://www.MySQL.com/downloads/ Java on your desktop/laptop. Download and Install: https://www.java.com/en/download/manual.jsp In this tutorial, we’ll be using an IDE (Integrated Development Environment) called eclipse. If you …