Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Float not correct in MySQL

Tags:

php

floating-point

mysql

precision

I am entering '35444650.00' as a float into my MySQL and it keeps reformatting to 35444648.00, any help welcome...

like image 810
jimbo Avatar asked Dec 03 '22 06:12

jimbo

1 Answers

Floats only have a certain level of precision, you may be going beyond how precise a float data type can be. Try using a DOUBLE instead.

like image 169
tloach Avatar answered Dec 17 '22 12:12

tloach
Sign in to Comment

Related questions

Laravel 5 force HTTPS issue with login routing to HTTP
how to send attachment files to email using laravel
Laravel extend TestResponse class
Using unset() function in an array to delete elements
How to use google-api-php-client on laravel 5.6 when there is no namespace
Laravel- redirect with variable and display it in the view file
DELETE request in laravel
how to upgrade laravel 6 to 7
PHP Installation: Error: It is not possible to switch enabled streams of a module
Restricting file downloads
Using PHP to Access a User's Webcam
What program do you use to edit php remotely and then upload to your server? [closed]
jquery $.post empty array
PHP passing messages between pages
Is it better to use a prepared Select statement when you are only doing one select?
Centralized error reporting in PHP
How do i fetch my file's absolute path
Which Linux distro is best for running in a virtual machine, for programming research?
How to send HTML/CSS emails?
Tinymce - insert html code

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!