FLOAT and DOUBLE data types are data types that can be used to store numbers that can include decimal numbers. They are specifically used to store estimates. What do I mean? I mean that the precision of a FLOAT or DOUBLE value can be lost when doing math. The data types are only capable of maintaining a certain level of precision. The level of precision is usually adequate for most mathematical operations. If you need to store exact data, you will want to look into using the INT or DECIMAL data type instead.
The numbers stored in a FLOAT or DOUBLE column are called floating point numbers, we'll see why in just a moment.
Why are they called floating point numbers? let's look at a number. 150. This number could be represented as 150, or it could be represented as 1.5 * 10^2, or 1.5e2. With floating point numbers, scientific notation is used. These numbers are called floating point numbers because the decimal can float to different spots as we change the exponent.
This means that the data type needs to store the number, how many decimal the number needs moved, and a sign bit.
The benefit of floating point numbers is that they allow us to store pretty huge numbers. The down side is that they are not storing values exactly because they are limited in size. This means that only a certain level of precision is to be expected from a floating point data type.
If you remember from the video of DECIMAL, precision is the number of digits in a number. As long as the precision for one of these data types exceeds the need for your specific data, the data type can work fine. For example, if you are storing a number like 15 trillion, you don't have to worry as much with precision as your number does not contain a lot of digits. This number can be represented as 1.5 x 10^13. This is a lot different than trying to store 1.5534534534 x10^13.
Now we know both of these data types do not maintain a high number of digits correctly, but what is the difference between FLOAT and DOUBLE. The difference is the amount of storage they take up. Float takes up 4 bytes while DOUBLE takes up 8. The benefit in DOUBLE is that because it has more room to store data, it has a higher level of precision and can store bigger numbers.
Now, what level of precision can you expect from either of these? FLOAT around 7 and DOUBLE around 15. Now, these data types are obnoxious because the exact values depend on your operating system and in general these monsters cannot be trusted. Especially when you start doing math with different numbers. In general, it is recommended to use the DOUBLE data type to have a higher level of precision and calculations in MySQL are done with DOUBLE.
Always remember… prepare for trouble, make it double.
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
More content: http://CalebCurry.com
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Wish you were online right now Caleb! Sure could use your help in getting this DB set up and running for a class project. I installed it wrong not knowing I did and been lost since I found out I did...lmao....gggrrrrr! I'm newb in DBM, but gotta know it, not only for school but for the businesses I'm building. You rock Caleb and will be watching these videos over and over again all night and day if need be!
hey ya a big fan of yours,i need a help ,I need to bring my database online so that it can be remotely accessed from my freinds computer"s mysql connectivity java program using jdbc:which will try to connect using the public ip of which i have to make my database remotely accesed;What i am basically asking is how to make mysql database remotely accesed using public ip so that it can be accesed through the jdbc mysql connectivity program
hope you reply soon:)
More like:how to make adatabase online so that it can be accesed by an javaprogram frm anywhere
using an dynamic public ip
or any other way of ur choice
Marin Community Foundation and Asian Americans/Pacific Islanders in Philanthropy.
Overall, US-born Muslims make up the largest percentage at 34% of all Muslims in the Bay Area, followed by 14% born in Pakistan, 11% in Afghanistan, 10% in India, 3% in Egypt and 2% each in Iran, Jordan, Palestine and Yemen.
Silicon Valley Pakistani-American by the Numbers:
There are 35,000 Pakistani-born Muslims in San Francisco Bay Area, or 14% of the 250,000 Muslims who call the Bay Area home, according to the study. Bay Area Muslim community constitutes 3.5 percent of the area’s total population and is one of the highest concentrations of Muslims in the country.
As of 2013, South Asian Muslims, including Pakistanis, have the highest income levels, with nearly half (49%) of them having a household income above $100,000. In comparison, those groups with the lowest proportion of household incomes above $100,000 were Hispanic Muslims (15%), Afghans (10%), and African American Muslims (10%).
The Bay Area Muslim community is very diverse in terms of race and ethnicity:
South Asians (30%)
African Americans (9%)
Asian/Pacific Islanders (7%)
Based on the survey findings, the majority of Muslims live in the following three counties:
and Contra Costa (12%)
Thousands of Pakistan-born techies are working at Apple, Cisco, Google, Intel, Oracle and hundreds of other high-tech companies from small start-ups to large Fortune 500 corporations. Pakistani-Americans are contributing to what Erik Brynjolfsson and Andrew McAfee describe as "The Second Machine Age" in a recent book with the same title.