What is the best data type to store millions in mySQL?

Question

Please, can anyone recommend me what is the best data type that will help me in SQL to store millions and hava a good precision? Also how to handle this data in python.

Answer 1

Rosana Rodríguez Milanés

If you wanna store millions of value then mediumint or BIGINT is sufficient for that!

Answer 2

You need to worry about which data type you are storing it can easily handle millions of row and columns.
Even if you have millions of data in your database it will take some millisecond to find specific value from the database or you can say in other words filtering the database. It all depends upon the SQL, not on python. Python is just like a tool which helps you to work with data in MySQL.

Answer 3

For integer types you can use 'int' or 'bigint' and for floating point values you can use either 'decimal' or 'float'.

And million is not a very big number so any of these could be used.