{"id":6381,"date":"2022-01-24T07:00:00","date_gmt":"2022-01-24T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=6381"},"modified":"2022-09-21T15:55:03","modified_gmt":"2022-09-21T10:25:03","slug":"mysql-number-function","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-number-function\/","title":{"rendered":"MySQL Number Function"},"content":{"rendered":"\n<p>MySQL Number Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0906\u092a \u0915\u093f\u0938\u0940 \u092d\u0940 Decimal \u0913\u0930 Number \u092f\u093e Integer Column \u092a\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0939\u092e\u0928\u0947 \u0907\u0938 Article \u092e\u0947 \u0938\u092c\u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0909\u092a\u092f\u094b\u0917 \u092e\u0947 \u0906\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u0941\u091b Number Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 Example \u0938\u0939\u093f\u0924 \u092c\u0924\u093e\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"list-of-mysql-number-function\">List of MySQL Number Function <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>ABS() :<\/strong>  Find Absolute Value <\/li><li><strong>DIV :<\/strong>  Find Integer Division <\/li><li><strong>MOD() :<\/strong>  Find Remainder <\/li><li><strong>ROUND() :<\/strong>  Find Round off  <\/li><li><strong>CEIL() or CEILING() :<\/strong> Find Round Up Nearest Integer<\/li><li><strong>FLOOR() :<\/strong> Find Round Down or Remove Decimals  <\/li><li><strong>TRUNCATE() :<\/strong> Remove Decimal or Truncate Decimal  <\/li><li><strong>CONV() :<\/strong> One Number System to Another Number System Conversion (Number System Base Change) <\/li><li><strong>POWER() :<\/strong> Find Power of Given Number  <\/li><li><strong>SQRT() :<\/strong> Find Square Root  <\/li><li><strong>RAND() :<\/strong> Generate Random floating-point Numbers   <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-abs-find-absolute-value\">MySQL ABS() : Find Absolute Value<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 Negative Number \u0915\u094b Positive number \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f ABS() Absolute Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0939\u092e Function \u092e\u0947 Positive Number Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0935\u0939 As it is \u0939\u0940 Return \u0939\u094b \u091c\u093e\u090f\u0917\u093e , \u0914\u0930 \u092f\u0926\u093f \u0906\u092a Negative Value Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0935\u0939 Positive \u092e\u0947 change \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT abs(-9) , abs(9)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"117\" height=\"44\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-60.png?resize=117%2C44&#038;ssl=1\" alt=\"MySQL ABS() Function : Find Absolute Value\" class=\"wp-image-6459\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-div-find-integer-division\">MySQL DIV : Find Integer Division<\/h2>\n\n\n\n<p>Integer Value \u0915\u0947 Division \u0915\u0947 \u0932\u093f\u090f \u0939\u092e MySQL DIV \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u092f\u0926\u093f \u0906\u092a Parameter \u092e\u0947 Decimal Value Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u092d\u0940 Result Integer \u092e\u0947 \u0939\u0940 \u0906\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT 24 DIV 2 , 12.5 DIV 2, 6.99 DIV 1.99<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"249\" height=\"39\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-71.png?resize=249%2C39&#038;ssl=1\" alt=\"MySQL DIV : Find Integer Division\" class=\"wp-image-6490\"\/><\/figure>\n\n\n\n<p>MySQL DIV \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Divide \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u094b Value \u0906\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0939\u0940 Integer \u092e\u0947 Convert \u0915\u0930 Return \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0939 \u0906\u092a 3rd Example \u0938\u0947 \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u092f\u0926\u093f 6.99 \/ 1.99 \u0915\u093f\u092f\u093e \u091c\u093e\u090f \u0924\u094b 3.51 \u0906\u090f\u0917\u093e \u0914\u0930 \u092f\u0926\u093f 3.51 \u0915\u094b Integer \u092e\u0947 Convert \u0915\u093f\u092f\u093e \u091c\u093e\u090f \u0924\u094b 3 \u0906\u090f\u0917\u093e\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-mod-find-remainder\">MySQL MOD() : Find Remainder<\/h2>\n\n\n\n<p>MySQL MOD \u0915\u094b Modulus \u0914\u0930 Modulo \u092d\u0940 \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 , \u091c\u092c \u092d\u0940 \u0939\u092e \u0915\u093f\u0938\u0940 \u0938\u0916\u094d\u092f\u093e \u0915\u094b \u0905\u0928\u094d\u092f \u0915\u093f\u0938\u0940 \u0938\u0916\u094d\u092f\u093e \u0938\u0947 \u092d\u093e\u0917 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0940 Divide \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0926\u093f \u0935\u0939 \u092a\u0942\u0930\u0940 \u0924\u0930\u0939 \u0938\u0947 divide \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0924\u094b \u0905\u0902\u0924 \u092e\u0947 \u0915\u0941\u091b \u0936\u0947\u0937 \u092c\u091a \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u091c\u0940\u0938\u0947 \u0915\u0940 \u0939\u092e Remainder \u0915\u0939\u0924\u0947 \u0939\u0948\u0902,  Remainder Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MySQL Mod Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT MOD(25,2)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"85\" height=\"45\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-62.png?resize=85%2C45&#038;ssl=1\" alt=\"MySQL MOD() Function: Find Remainder\" class=\"wp-image-6467\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"round-find-round-off\">ROUND() : Find Round off <\/h2>\n\n\n\n<p>Decimal Value \u0915\u094b Round off \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MySQL Round function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a \u0915\u0947\u0935\u0932 \u090f\u0915 \u0939\u0940 Parameter pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u092c \u0926\u0940 \u0917\u0908 value \u092f\u0926\u093f .5 \u0914\u0930 \u0909\u0938\u0938\u0947 \u092c\u095c\u0940 \u0939\u0948\u0902 \u0924\u094b +1 \u0939\u094b \u091c\u093e\u090f\u0917\u0940 \u0913\u0930 \u092f\u0926\u093f .5 \u0938\u0947 \u091b\u094b\u091f\u0940 \u0939\u0948\u0902 \u0924\u094b Decimal \u0915\u0947 \u092c\u093e\u0926 \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 Remove \u0939\u094b \u091c\u093e\u090f\u0917\u0940 \u0964 <\/p>\n\n\n\n<p>\u0914\u0930 \u092f\u0926\u093f \u0906\u092a Second parameter \u092e\u0947 \u0915\u094b\u0908 Value \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0928\u0947 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 number \u0926\u093f\u090f \u0939\u0948\u0902 \u0909\u0924\u0928\u0947 Decimal Point \u0915\u0947 \u092c\u093e\u0926 \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0928\u093f\u092f\u092e \u0905\u0928\u0941\u0938\u093e\u0930 Round Off \u0939\u094b\u0917\u0940 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT round(9.4) as r union ALL\nSELECT round(9.5) union ALL\nSELECT round(9.6) union ALL\nSELECT round(12.6123,2) union ALL\nSELECT round(12.6953,2)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"54\" height=\"109\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-63.png?resize=54%2C109&#038;ssl=1\" alt=\"ROUND() : Find Round off \" class=\"wp-image-6469\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-ceil-or-ceiling-find-round-up-nearest-integer\">MySQL CEIL() or CEILING() : Find Round Up Nearest Integer<\/h2>\n\n\n\n<p>MySQL Ceil or Ceiling \u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 \u0939\u092e \u0926\u0940 \u0917\u0908 Decimal value \u0915\u094b Roundup \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f point \u092e\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 \u0925\u094b\u095c\u0940 \u092d\u0940 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 \u0909\u0938\u0947 \u092c\u095c\u093e\u0915\u0930 next Integer value \u092a\u0930 \u0938\u0947\u091f \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT CEIL(9.4) as c union ALL\nSELECT CEIL(9.5) union ALL\nSELECT CEIL(9.6) union ALL\nSELECT CEIL(12.6123) union ALL\nSELECT CEILING(12.6953)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"34\" height=\"111\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-64.png?resize=34%2C111&#038;ssl=1\" alt=\"MySQL Ceil Function : Round Up Nearest Integer\" class=\"wp-image-6472\"\/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 9.4, 9.5, 9.6 \u0924\u0940\u0928\u094b\u0902 \u0939\u0940 Condition \u092e\u0947 Return 10 \u0906\u092f\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u0932\u093f\u090f \u0907\u0938\u0947 Roundup \u092d\u0940 \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-floor-find-round-down-or-remove-decimals\">MySQL FLOOR() : Find Round Down or Remove Decimals <\/h2>\n\n\n\n<p>MySQL Floor Function MySQL Ceil \u0915\u0947 \u0935\u093f\u092a\u0930\u0940\u0924 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 \u091c\u094b \u092d\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u0906\u092a Parameter \u092e\u0947 Pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0909\u0938\u092e\u0947 \u0938\u0947 Decimal Remove \u0939\u094b \u0915\u0930 Value Return \u0939\u094b \u091c\u093e\u090f\u0917\u0940,  \u091c\u0948\u0938\u093e \u0915\u0940 \u0928\u093f\u092e\u094d\u0928 Example \u092e\u0947 \u0926\u093f\u0916\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0915\u0940 \u091c\u092c \u0939\u092e\u0928\u0947 9.4, 9.5, 9.6 \u0926\u093f\u092f\u093e \u0924\u094b \u0924\u0940\u0928\u094b\u0902 \u0938\u0902\u0916\u094d\u092f\u093e \u092e\u0947 \u0938\u0947 Decimal \u0935\u093e\u0932\u0940 Value Decrease \u0939\u0941\u0908 \u092f\u093e Remove \u0939\u094b \u0915\u0930 9 \u0939\u0940 Return \u0906\u092f\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT FLOOR(9.4) as c union ALL\nSELECT FLOOR(9.5) union ALL\nSELECT FLOOR(9.6) union ALL\nSELECT FLOOR(12.6123) union ALL\nSELECT FLOOR(12.6953)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"34\" height=\"110\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-65.png?resize=34%2C110&#038;ssl=1\" alt=\"\" class=\"wp-image-6475\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-truncate-remove-decimal-or-truncate-decimal\">MySQL TRUNCATE() : Remove Decimal or Truncate Decimal <\/h2>\n\n\n\n<p>MySQL Truncate \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0906\u092a decimal \u0938\u0902\u0916\u094d\u092f\u093e \u092e\u0947 \u0938\u0947 Decimal \u0915\u0947 \u092c\u093e\u0926 \u0915\u0940 value \u0915\u094b Remove \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0938\u093e\u0925 \u092e\u0947 \u0907\u0938\u092e\u0947 \u090f\u0915 Parameter \u0914\u0930 \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u0906\u092a \u091c\u094b number pass \u0915\u0930\u0947\u0902\u0917\u0947 \u0909\u0924\u0928\u0947 Decimal \u0915\u0947 \u092c\u093e\u0926 \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 Remove \u0939\u094b \u091c\u093e\u090f\u0917\u0940 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947 \u0915\u0947\u0935\u0932 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0940 Remove \u0939\u094b\u0917\u0940 \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Round up \/ down \/ off \u0928\u0939\u0940\u0902 \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT TRUNCATE(9.4,0) as c union ALL\nSELECT TRUNCATE(9.5,0) union ALL\nSELECT TRUNCATE(9.612,2) union ALL\nSELECT TRUNCATE(12.6123,0) union ALL\nSELECT TRUNCATE(12.6953,2)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"52\" height=\"110\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-66.png?resize=52%2C110&#038;ssl=1\" alt=\"\" class=\"wp-image-6477\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>\u00a0<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-conv-function-one-number-system-to-another-number-system-conversion-number-system-base-change\">MySQL CONV() Function : One Number System to Another Number System Conversion (Number System Base Change)<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 Calculation \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e Decimal Number System \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , computer Binary Number System \u0915\u094b \u0938\u092e\u091d\u0924\u093e \u0939\u0948\u0902, \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u092c\u0939\u0941\u0924 \u0938\u0947 number System \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 , \u0906\u092a \u092d\u0940 Conv Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Number \u0915\u0940 Base  value \u0926\u0947 \u0915\u0930 Conversion  \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 .<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Binary Number System \u092e\u0947 Number \u0915\u0940 Base 2 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 <\/li><li>Octal Number System \u092e\u0947 Number \u0915\u0940 Base 8  \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 <\/li><li>Decimal Number System \u092e\u0947 Number \u0915\u0940 Base 10 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902  \u0914\u0930 <\/li><li>Hexadecimal Number System \u092e\u0947 Number \u0915\u0940 Base 16  \u0939\u094b\u0924\u0940 \u0939\u0948\u0902  <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT 'Binary to Decimal ' as remark, CONV(1010, 2, 10) as VAL  UNION ALL\nSELECT 'Binary to Octal ' as remark, CONV(1010, 2, 8) as VAL  UNION ALL\nSELECT 'Binary to Hexadecimal ' as remark, CONV(1010, 2, 16) as VAL  UNION ALL\nSELECT 'Decimal to Binary ' as remark, CONV(1501, 10, 2) as VAL<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"225\" height=\"95\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-67.png?resize=225%2C95&#038;ssl=1\" alt=\"MySQL CONV() Function : One Number System to Another Number System Conversion (Number System Base Change)\" class=\"wp-image-6479\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-power-find-power-of-given-number\">MySQL POWER() : Find Power of Given Number <\/h2>\n\n\n\n<p>MySQL POWER \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e \u0926\u093f\u090f \u0917\u090f number \u0915\u0940 Power (\u0918\u093e\u0924) \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0939\u092e\u0947 25 \u0915\u0940 \u0918\u093e\u0924 2 \u0928\u093f\u0915\u093e\u0932\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0939\u092e \u0907\u0938 \u092a\u093e\u0930\u094d\u0915\u0930 \u0938\u0947 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT POWER(25,2)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-68.png?resize=94%2C34&#038;ssl=1\" alt=\"MySQL POWER() Function : Find Power of Given Number \" class=\"wp-image-6482\" width=\"94\" height=\"34\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-sqrt-find-square-root\">MySQL SQRT() : Find Square Root <\/h2>\n\n\n\n<p>SQRT \u0915\u093e full form Square Root \u0939\u094b\u0924\u093e \u0939\u0948\u0902 , \u092f\u0926\u093f \u0906\u092a\u0915\u0940 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u0915\u093e Square Root Find \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0906\u092a MySQL SQRT \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT SQRT(4)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"78\" height=\"39\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-69.png?resize=78%2C39&#038;ssl=1\" alt=\"MySQL SQRT() Function : Find Square Root \" class=\"wp-image-6483\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-rand-generate-random-floating-point-numbers\">MySQL RAND() : Generate Random floating-point Numbers  <\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0915\u094b\u0908 \u092d\u0940 Decimal Random Number Generate \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0906\u092a MySQL Rand \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u0906\u092a \u0907\u0938 \u092b\u0902\u0917\u0915\u094d\u0936\u0928 \u0915\u094b \u091c\u093f\u0924\u0928\u0940 \u092c\u093e\u0930 Execute \u0915\u0930\u0947\u0902\u0917\u0947 \u0939\u0930 \u092c\u093e\u0930 \u0915\u094b\u0908 \u0905\u0932\u0917 \u0939\u0940 value \u0906\u090f\u0917\u0940 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT RAND(), RAND(), RAND()<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"455\" height=\"44\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-72.png?resize=455%2C44&#038;ssl=1\" alt=\"MySQL RAND() Function : Generate Random floating-point Numbers  \" class=\"wp-image-6513\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-72.png?w=455&amp;ssl=1 455w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-72.png?resize=300%2C29&amp;ssl=1 300w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p><br>\u0939\u092e\u0928\u0947 MySQL Number Function \u092e\u0947 \u0905\u0924\u094d\u092f\u0927\u093f\u0915 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947 \u0906\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u0941\u091b Number Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 Example \u0938\u0939\u093f\u0924 \u092c\u0924\u093e\u092f\u093e \u0939\u0948\u0964 <\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f <\/p>\n\n\n\n<p>\u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964 <\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Number Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0906\u092a \u0915\u093f\u0938\u0940 \u092d\u0940 Decimal \u0913\u0930 Number \u092f\u093e Integer Column \u092a\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0939\u092e\u0928\u0947 \u0907\u0938 Article \u092e\u0947 \u0938\u092c\u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0909\u092a\u092f\u094b\u0917 \u092e\u0947 \u0906\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u0941\u091b Number Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 Example \u0938\u0939\u093f\u0924 \u092c\u0924\u093e\u092f\u093e \u0939\u0948\u0902 \u0964 List of MySQL Number Function ABS() : Find Absolute Value DIV : Find Integer Division [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6527,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-6381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/MySQL-Number-Function.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=6381"}],"version-history":[{"count":67,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6381\/revisions"}],"predecessor-version":[{"id":9242,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/6381\/revisions\/9242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/6527"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=6381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=6381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=6381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}