How to Rename Table in MySQL?
Summary: In this post, we will learn how to rename an existing table using the MySQL RENAME TABLE statement in MySQL. Introduction to RENAME TABLE The general syntax to rename…
0 Comments
August 27, 2020
How to Delete a MySQL User?
In our earlier post we had discussed how to create a new user account in MySQL. Now in this post, we will discuss how to delete a MySQL user account…
August 23, 2020
How to Delete a Table in MySQL?
In this post, we will discuss how to delete an existing table in MySQL using the MySQL shell or command line. The general syntax to delete any existing table in…
August 23, 2020
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?
In this post, we will discuss how to add columns into the table in MySQL and how to delete existing columns from the table in MySQL database. Prerequisite: MySQL Table…
August 21, 2020
How to Create a New User and Grant Permissions in MySQL
In this post, 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 will…
August 20, 2020
![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 discussed about Self Referencing Foreign Key while talking about Foreign Key in MySQL. So let's see what actually is self-referencing Foreign Key in…
August 19, 2020
![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]
In this post, we will discuss what is Foreign Key in MySQL? How to create a table with Foreign key? and How to add and remove Foreign Key from a…
August 18, 2020
![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]
In this post, 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 primary…
August 16, 2020
How to Create Table in MySQL?
In this post, we will discuss how to create a table in MySQL using the command line and phpMyAdmin? According to MySQL documentation, the general syntax to create a table…
August 14, 2020