MySQL: What’s the difference between float and double?

They both represent floating point numbers. A FLOAT is for single-precision, while a DOUBLE is for double-precision numbers.

MySQL uses four bytes for single-precision values and eight bytes for double-precision values.

There is a big difference from floating point numbers and decimal (numeric) numbers, which you can use with the DECIMAL data type. This is used to store exact numeric data values, unlike floating point numbers, where it is important to preserve exact precision, for example with monetary data.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. MySQL Error “Operand should contain 1 column”
  4. How to use MySQL DECIMAL?
  5. MySQL ERROR 1290 (HY000) –secure-file-priv option
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Setting up foreign keys in phpMyAdmin?
  8. Duplicating a MySQL table, indices, and data
  9. mysql Foreign key constraint is incorrectly formed error
  10. SELECT * FROM multiple tables. MySQL
  11. MySQL error code: 1175 during UPDATE in MySQL Workbench
  12. mysql: SOURCE error 2?
  13. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  14. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  15. MySQL foreach loop
  16. MySQL IF NOT NULL, then display 1, else display 0
  17. MySQL Server on MAMP-Windows Will Not Start
  18. SQL statement not working – “Operand type clash: date is incompatible with int’
  19. MySQL Calculate Percentage
  20. Repair all tables in one go
  21. #1214 – The used table type doesn’t support FULLTEXT indexes
  22. importing a CSV into phpmyadmin
  23. How can I rebuild indexes and update stats in MySQL innoDB?
  24. MySQL Select Multiple VALUES
  25. MySQL Error 1215: Cannot add foreign key constraint
  26. How to use the keyword ‘references’ in MySQL?
  27. select * from table where column = something or, when unavailable, column = something else
  28. Differences between utf8 and latin1
  29. Solution to “subquery returns more than 1 row” error
  30. There can be only one auto column
  31. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  32. What SQL Query to do a simple find and replace
  33. What are the recommended database permissions for WordPress?
  34. What’s a good strategy for planning WordPress DB growth?
  35. How can I find the source of slow queries in WordPress?
  36. $wpdb and MySQL Create Trigger
  37. Fulltext search in posts sorted by relevancy
  38. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  39. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  40. How can I make wordpress suppress mysql errors?
  41. How to bulk delete all WordPress subscribers?
  42. wpdb insert and boolean fields
  43. Error while importing database
  44. What are the issues associated with upgrading MySQL for WordPress?
  45. Changing Table Prefix for an Existing WordPresss Site
  46. How to find meta entries with their posts missing via SQL?
  47. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  48. Connect another DB and fetch records from some tables
  49. Can I restart MySQL engine when WordPress website is live?
  50. Error: MySQL shutdown unexpectedly [closed]
  51. Why my wordpress loopback traffic while socket is setup?
  52. Update or insert meta key value – On Duplicate key update
  53. Connect to MySQL using Windows Authentication
  54. Defining the same price to all WooCommerce Products
  55. Which is better and faster ? WordPress Queries or SQL Query
  56. Database Structure on Different Servers
  57. Using WPDB->Insert()
  58. Active DB queries in WordPress?
  59. Run Username SQL Query from WordPress Child Theme Functions File
  60. How to get INSERT errors from $wpdb?
  61. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  62. Export Yoast Keywords from MySQL/phpMyAdmin
  63. Same database; different WordPress
  64. MySQL query for taxonomy-meta
  65. Sql – Search with serialized Data / better database concept
  66. How to insert dash (-) into database using wpdb and new_to_publish hook?
  67. MySQL: How to change url in posts from xxx.com to yyy.org?
  68. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  69. Getting data from Mysql Table..confusing
  70. SQL Statement – Mass Delete Custom Post Types
  71. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  72. Upgrade DB Loop – WordPress DB Version Conflict
  73. WordPress & MySQL , problem with use many array in meta_query
  74. latency problems with wordpress install (from SQL import)
  75. mysql – Delete keyword with link from wordpress post database
  76. Creating dynamic content and pages for 1000’s of locations
  77. Remove duplicate media entries from mysql database
  78. Button writing to MYSQL database
  79. MySQL ‘duplicate entry’ error
  80. WordPress Dutch characters encoding problem
  81. How to show result of sql query in a page?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. How do I insert content of various MySQL fields in post?
  84. Select latest 2 articles, but only from given category
  85. CONCAT_WS in custom sql query
  86. Query does not filter duplicate _sku numbers
  87. Ordering topics by most replies in X days using MYSQL statement
  88. MySQL Select within WP Page template
  89. wp_postmeta – lot of meta fields
  90. Running WordPress from MySQL Cluster with HAPRoxy
  91. Delete posts with word count less than x number of words
  92. MySQL: get post_tag items that are tags (not SEO keywords)
  93. $wpdb->get_var returns 0
  94. cannot log in to the mysql server (wamp and wordpress)
  95. SQL command to export post_content from wp_posts using phpMyAdmin
  96. Why can’t I connect to imported WP DB on local MAMP?
  97. Where other than wp-config can database access details be defined?
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment