What MySQL data type should be used for Latitude/Longitude with 8 decimal places?

by

MySQL supports Spatial data types and Point is a single-value type which can be used. Example:

CREATE TABLE `buildings` (
  `coordinate` POINT NOT NULL,
  /* Even from v5.7.5 you can define an index for it */
  SPATIAL INDEX `SPATIAL` (`coordinate`)
) ENGINE=InnoDB;

/* then for insertion you can */
INSERT INTO `buildings` 
(`coordinate`) 
VALUES
(POINT(40.71727401 -74.00898606));

More Related Contents:

  1. What is the size of column of int(11) in mysql in bytes?
  2. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  3. Types in MySQL: BigInt(20) vs Int(20)
  4. What data type to use for hashed password field and what length?
  5. What is the benefit of zerofill in MySQL?
  6. MySQL floating point comparison issues
  7. mysql equivalent data types
  8. storing money amounts in mysql
  9. In SQL Server how to get the count of child if both parent and child are available [closed]
  10. Get a list of dates between two dates
  11. How to change max_allowed_packet size
  12. What does character set and collation mean exactly?
  13. How do MySQL indexes work?
  14. How to change MySQL data directory?
  15. Query to get all rows from previous month
  16. Why can’t a text column have a default value in MySQL?
  17. Find and Replace text in the entire table using a MySQL query
  18. Can I reuse a calculated field in a SELECT query?
  19. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  20. Deleting duplicate rows from a table
  21. Is it safe to store usernames and passwords in the database?
  22. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  23. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
  24. Compare only day and month with date field in mysql
  25. mysql, ifnull vs coalesce, which is faster?
  26. MySQL delimiter syntax error
  27. Can a MySQL query turn rows into columns?
  28. How to import large sql file in phpmyadmin
  29. How to figure out size of Indexes in MySQL
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment