Blog – Page 2 – Pencil Programmer

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…

MySQL

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…

MySQL

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…

MySQL

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…

MySQL

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…

MySQL

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…

Courses

Best Free and Paid Courses to Learn Python Online in 2020

Python is the go-to language for data science, machine learning, and web development when it comes to programming. In fact, except game development literally you can do anything using python.…