Operators in MySQL



Hello and welcome everyone. In this article we will learn about Operators 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 operators compare two or more expressions and it returns true if the expressions are true. There are many operators available in MySQL like assignment operators, logical operators, arithmetic operators, bitwise operators and many more. Now we will see in details operators.
Following are the various types of operators available in MySQL:

1.    Logical Operators
2.    Arithmetic Operators
3.    Bitwise Operators
4.    Assignment Operators
5.    Comparison Operators


1.        Logical Operators

AND ( &&)
          It is a logical AND (&&) operator. If the all conditions are true, then AND separated by true conditions.


BETWEEN
          The between operators check value is within a range of values.

IN
          The IN operator check value is present or not in list.

LIKE
          The LIKE operator simple pattern matching operator with % and _.

NOT ( ! )
          The NOT (!) operator negates values or display a record if the conditions is not true.

OR ( || )
          It is a logical OR ( || ) operator and it is a non-standard MySQL extension.


2.        Arithmetic Operators

Add ( + )
          It is an addition operator in MySQL.
         
Subtract ( - )
          It is a minus operator in MySQL.

Multiply ( * )
          It is a multiplication operator in MySQL.

Divide ( / )
          It is a division operator in MySQL.

Modulo ( % )
          It is modulo operator in MySQL.


3.        Bitwise Operators

AND ( & )
          It is a bitwise AND operator.

OR ( | )
          It is a bitwise OR operator.

Exclusive OR ( ^ )
          It is a bitwise exclusive OR operator.





4.        Assignment Operators

=
          Assignment operator is a part of a SET statement and also part of the SET clause in an UPDATE statement. It Assign a value.
         
:=
          This operator assigns a value.
              
5.        Comparison Operators

Equal to ( = )
          It is an equal to and comparison operators.

Greater than ( > )
          It is a greater than operators.


Less than ( < )
          It is a less than operator.

Greater than or equal to ( >= )
          It is a greater than or equal to operator.

Less than or equal to ( <= )
          It is a less than or equal to operator.

Not equal to ( <> )
          It is a not equal to operator.


In this article, we are learned about assignment operators, logical operators, arithmetic operators, bitwise operators.

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/

Visit our site: https://expertwithsagarjaybhay.com/

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

MySQL Constraint – PRIMARY KEY

Image
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/ Hello everyone in the previous article we learn about MySQL Constraint – UNIQUE and in this article, we will learn PRIMARY KEY constraint with example. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ What is the PRIMARY KEY? MySQL PRIMARY KEY constraint uniquely identifies each row in a table and also it creates a unique index for accessing the table will access faster. The columns of a Primary Key cannot have null values in MySQL and it must contain unique values. A Primary key has only one on a table, if the primary key used with multiple fields, then they are called a Composite Key. Syntax 1 for creating PRIMARY KEY with CREATE table statement.      ...
Read more

Order By Clause in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Order By Clause 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 Order by clause is used to sort the records or data in ascending or descending order. Order by clause allows us to sort records or data by a single column or multiple columns in ascending or descending order. There are two key using in Order by clause:          ASC: - sorting data or records by ascending order.          DESC: - sorting data or records by descending order. Syntax:          SELECT column_name_1, column_n...
Read more