MySQL Arithmetic Functions tutorial in Hindi -27

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();

You May Also Like

प्रातिक्रिया दे

आपका ईमेल पता प्रकाशित नहीं किया जाएगा. आवश्यक फ़ील्ड चिह्नित हैं *