How to Delete a Table in MySQL?
Summary: In this tutorial, we will leanr how to delete an existing table in MySQL using the MySQL shell or command line. The general syntax to delete any existing table…
0 Comments
August 23, 2020
The post related to the MySQL database. MySQL is an open-source relational database management system (RDBMS).
How to Delete a Database in MySQL?
We learned how to create a database in MySQL in our earlier post but we didn't discuss how to delete an existing database in MySQL. So in this post let's…
August 22, 2020
How to Add and Delete Columns in MySQL?
Summary: In this tutorial, we will learn how to add columns to the table in MySQL and how to delete existing columns from the table in the MySQL database. Prerequisite:…
August 21, 2020
How to Create a New User and Grant Permissions in MySQL
Summary: In this tutorial, we will discuss how to Create a New User in MySQL and grant permissions to it using the MySQL Shell or MySQL Command-Line. Most important we…
August 20, 2020
![Read more about the article Self Referencing Foreign Key in MySQL [Explained]](https://pencilprogrammer.com/wp-content/uploads/2020/08/self-referencing-foreign-key-in-MySQL.jpg)
Self Referencing Foreign Key in MySQL [Explained]
In our previous post, we did not discuss Self Referencing Foreign Key while talking about Foreign Key in MySQL. So let's see what actually is self-referencing Foreign Key in MySQL…
August 19, 2020
![Read more about the article Everything about Foreign Key in MySQL [with Examples]](https://pencilprogrammer.com/wp-content/uploads/2020/08/Foreign-Key-in-MySQL.jpg)
Everything about Foreign Key in MySQL [with Examples]
Summary: In this tutorial, we will learn what a Foreign Key is in RDBMS and how can we create Foreign keys in MySQL. In addition, we will also learn to…
August 18, 2020
![Read more about the article Everything about Primary Key in MySQL [with Examples]](https://pencilprogrammer.com/wp-content/uploads/2020/08/primary-key-in-MySQL.jpg)
Everything about Primary Key in MySQL [with Examples]
Summary: In this tutorial, we will discuss what is the primary key in MySQL? How to create a table with the primary key? and How to add and remove a…
August 16, 2020
How to Create Table in MySQL?
Summary: In this tutorial, we will learn to create a table in the MySQL database using the command line and phpMyAdmin interface. According to MySQL documentation, the general syntax to…
August 14, 2020
How to Create Database in MySQL?
In this post, we will discuss how to create a database in MySQL using the command line and phpMyAdmin. According to MySQL documentation, the general syntax to create a database…
August 12, 2020