MySQL Arithmetic Operators - MySQL Tutorial 31

Notes for You:: MySQL Arithmetic Operators - MySQL Tutorial 31

Addition Operator (+):
- gives sum of two numbers.

Subtraction Operator (-):
- gives difference between two numbers.

Multiplication Operator (*):
- gives product of two numbers.

Floating-point Division Operator (/):
- gives quotient of the division operation as floating point value.

Integer Division Operator (DIV) :
- gives integer part of the quotient.

Modulus Operator (% or mod):
- gives remainder of the first division operation.

Example Code:
select 10 + 2; // 12
select 10 - 2; // 8
select 10 * 2; // 20
select 10 / 2; // 5.000
select 10 div 2; // 5
select 11 / 2; // 5.500
select 11 div 2; // 5
select 10 % 2; // 0
select 11 % 2; // 1
select 10 mod 2; // 0
select 11 mod 2; // 1

Example Code:
update tbl_faculty set salary = salary * 2 where id = 2;
update tbl_faculty set salary = salary - 2000 where id = 3;

=========================================

Follow the link for next video:
MySQL Tutorial 32 - How to use Relational Operators in MySQL

Follow the link for previous video:
MySQL Tutorial 30 - Operators in MySQL | MySQL Operators

=========================================

MySQL Tutorials Playlist:-

=========================================
Watch My Other Useful Tutorials:-

PHP Tutorials Playlist:-

JavaScript Tutorials Playlist:-

HTML Quick Tutorials Playlist:-

=========================================

HI, I am Manjunath Chidre and I'm an Indian born. I make video tutorials on Computer Science, Information Technology, Animation, VFX, Multimedia, & Gaming courses. Essentially, I set my goal to help students around the world; to learn at free of cost; through my educational YouTube channel Chidre'sTechTutorials.

=========================================

Every video on my channel is made with Love and Hard work, So don't forget to Like, Comment & Share.
Please do Subscribe, Hit the bell icon & Enjoy Learning. It's FREE.

=========================================

Subscribe to our YouTube channel:-

Join as Member of our YouTube channel:-

Become our Patron:-

Visit our Website:-

Download our Notes from Instamojo:-

Buy our Products on Spring:-

=========================================
Follow Us:-

Google My Business:-

Google Blog:-

LinkedIn:-

Facebook:-

Twitter:-

Tumblr:-

Pinterest:-

=========================================

Despite my inconsistent uploads; Thanks for being amazing learners and still sticking with me on YouTube.

=========================================
Hash Tags:-
#ChidresTechTutorials #MySQL #MySQLTutorial

[ChidresTechTutorials]

Once you watch the video; answer the following questions:
1. Explain Arithmetic Operators in MySQL

[chalmerilexus]

You taught so many concepts in just 1 video...

[mahlud]

Sir, in your html, css tutorial you are using double quotation for creating EXTENTION, why is that? (because i knew that even without " " it goes well.
So, what is the importance of double quotation???