Two floats data-type for mysql using python

Question

I have a question please. I have this data and I want to insert in my SQL using python. I have created a table with 4 columns. for ID, title, description and geolocation respectively. My question is, for id (int), for title (varchar), for description (varchar). However, for geolocation I am confused. I have Loc and Lat together. I was told not to use varchar. So I used decimal, float and it did not work. The only hint given to me is I have 2 floats and that is how the data-type should be. What can I do?

('3', "Τάφρος Ντ'Αβίλα (D'Avila)", '-1', '35.169194,33.363113')

Rick James · Accepted Answer · 2022-07-07 16:54:49Z

1

If you intend to use a SPATIAL index to make certain searches more efficient, then see the POINT datatype.

Otherwise, consider using two FLOATs. That gives a resolution of 1.7 meters (5.6 feet).

If you will have a billion data points, the size of the datatype used matters; see http://mysql.rjweb.org/doc.php/latlng#representation_choices

answered Jul 7, 2022 at 16:54

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Two floats data-type for mysql using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related