MySQL Arithmetic Functions tutorial in Hindi AAJ IS ARTICLE KE MADHYAM SE SAMJHEG MYSQL KE ARITHMETIC KE BARE ME SAMJHENGE
MYSQL ARTITHEMETIC LIST
- PI() = YE HAME POSITIVE VALUE DETA HAI
- ROUND() = YE HAME EK ROUNDED VALUE DETA HAI
- CEIL() = YE HAME UPAR KI VALUE DETA HAI
- FLOOR = YE HAME NICHE KI VALUE DETA HAI
- POW() = BASE OR EXP ME VALUE DETA HAI BASE SE EXPO SE MULTIPLE KARTA HAI
- SQRT() = ISE HAM SQR ROUTE NIKAL SAKTE HAI
- RAND() = YE HAME EK RANDOM VALUE DETA HAI VO 0 SE 1 KE BICH ME HOTA HAI
- ABS() =
- SIGN() = YE HAME TIN VALUE DETA HAI 0, 1AND -1 AGAR KOI VALUE 0 SE KAM HAI TO -1 OR JYADA HAI TO1 OR AGAR BRABAR HAI TO 0 DETA HAI
- SIN()
- COS()
- TAN()
- ASIN()
- ACOS()
- ATAN()
- ATAN2()
- COT()
- RADIANS()
SELECT 5+6 AS TOTAL;
TOTAL MAINE EK FOLDER KA NAME DIYA HAI TEMPRARY ISKE BINA BHI AAP KAAM KAR SAKTE HAI OR ISE JOD KAR SKATE HAI IS TARAH KA AAP KOI BHI SINE USE KAR SKATE HAI. JAISE :- *, -,/, ECT.
OR ISKA JO PRCTILE USE HAI JAISE MAI KISI TABLE KE DATA KE SATH KUCHH ADD KARNA CHAHTA HUN TO ISKE LIYE HAM KUCHH IS TARIKE SE USE KARTE HAI.
SELECT ID, NAME,(PER + 5) FROM DATA;
AB IS PAR KE COLUMN ME 5 OR JUD GYE HAI NUMBER ME
SELECT round(4.51); YE HAME 5 RETURN KARTA HAI AGR .5 SE UPAR HAI TO HAME YE 5 DEGA OR NICHE HAI TO YE 4 DEGA
OR YE SABHI HAMEFUNCTION PHP ME BHI SIKHA HAI SAME HI KAAM ISKA HAI AAP USE BHI PADH SKATE HAI OR YA ISE BHI DEKH SAKTE HAI USE KARKE. MySQL Arithmetic Functions tutorial in Hindi
OR RAND() KA JYDA TAR ORDER BY KE SATH USE HOTA HAI.
SELECT * FROM TABLE_NAME ORDER BY RAND();