{"version":"1.0","provider_name":"Itxperts","provider_url":"https:\/\/itxperts.co.in\/blog","author_name":"@mritxperts","author_url":"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/","title":"MySQL Numeric Functions - Itxperts","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"ohYHqYzFpj\"><a href=\"https:\/\/itxperts.co.in\/blog\/all-numeric-functions-in-mysql-with-examples\/\">MySQL Numeric Functions<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/itxperts.co.in\/blog\/all-numeric-functions-in-mysql-with-examples\/embed\/#?secret=ohYHqYzFpj\" width=\"600\" height=\"338\" title=\"&#8220;MySQL Numeric Functions&#8221; &#8212; Itxperts\" data-secret=\"ohYHqYzFpj\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/itxperts.co.in\/blog\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","thumbnail_url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2024\/10\/mysql-1.webp","thumbnail_width":1792,"thumbnail_height":1024,"description":"In this blog post, we explore the essential numeric functions in MySQL, such as ABS(), CEIL(), FLOOR(), ROUND(), and MOD(). Each function is explained with examples to help you perform mathematical operations efficiently in your databases. Whether you're rounding numbers, calculating remainders, or generating random values, these functions will simplify your data manipulation tasks. Perfect for developers and database administrators looking to enhance their MySQL skills! Written by ITXperts"}