Comments

Post a Comment

Popular posts from this blog

ALTER statement in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the ALTER table statement in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL ALTER command is used to modify the table, view an existing database. When you have completed your database design and after that, you realize some of the information was left out when creating a database. You want to change without losing existing data, and then you can change data using ALTER command. MySQL ALTER command is used to add a column with an existing table, add multiple columns, drop a column, modify a column, rename a column, and rename the table. ALTER command also used to add and drop constraints on the existing table. ...
Read more

Like Operator in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Like Operator in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL LIKE operator is used with WHERE clause of SELECT, DELETE, UPDATE statement to search for a specified pattern in a column. LIKE operator allows us to perform pattern matching and were want to do an exact match. Following are the two wildcard characters provided in MySQL that creating patterns, Underscore ( _ ) – this wild card matches a single character from the table. For example, suppose we gave pattern like te_, now any string starts with te from the table then the character will display like tea or tennis or teen. Percentage ( % ) – this ...
Read more

Difference between Primary Key and Foreign Key in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the difference between Primary Key and Foreign Key. Let’s go. Primary Key and Foreign Key MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/               MySQL PRIMARY KEY constraint uniquely identifies each row in a table. MySQL FOREIGN KEY constraint uniquely identifies a row or record in another table.               MySQL PRIMARY KEY select candidate key, therefore, it does uniquely define the relation. MySQL FOREIGN KEY current table refers to the primary key of another table.   ...
Read more