mysql database-design maps mapping latitude-longitude

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?

Solution

Use MySQL's spatial extensions with GIS.

Why is my docker.compose file not creating my database?
"Database logon failed" in Crystal Reports when using System DSN for MySQL Server
Can I access the MySQL keypair in a plugin?
MySQL - Update table values from another table
Find patients admitted multiple times for the same primary diagnosis in SQL
Connecting a Dockerized Spring Boot app to a local MySQL Database
MySql: unknown column id in 'field list'
Is there a simple tool to convert mysql to postgresql syntax?
Why UNION and UNION ALL don't work in my code?
laravel eloquent ->whereHas - write your own exists( subquery )
MySQL server does not start with MAMP
Forward Engineer not creating tables from Model in MySQL Workbench
How can I make SQL case sensitive string comparison on MySQL?
MySQL - problem with comparing strings constants containing national characters
How to fix "java.sql.SQLException: Can't call commit when autocommit=true"
Balance calculation problem with Foreign Exchange in Mysql
Database Backup From Laravel Application
Joining tables with multiple results as new columns?
how to calculate average price of each item in inventory php mysql
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
How can I rebuild indexes and update stats in MySQL innoDB?
In MySQL, how can I create a stored procedure to create the database itself and then call this procedure from Java using JDBC?
InnoDB: Unable to lock ./ibdata1 error: 35
MySQL Order subquery by the order that fields from another table come in
UPDATE/INSERT when modifying RDBMSs using drill
Searching within nested JSON entries in MYSQL
Selecting empty mysql datetime fields
SQL Query: order by length of characters?
how do i add database name with hyphen character using script in ubuntu
Laravel 11 forces creation of tables you don't want and crashes the app