How to calculate more amount?

Question

MySQL

There are about 700k records in the table, in which there is an integer column where on average 5-6 characters.
Will MySQL be able to calculate their entire sum using the SUM() function? (the sum is greater than 6mlr)
And will MySQL be able to perform any operations with this sum of all rows?

Answer 1

Let's check it with a simple example:

create table t (
  a int
);

insert into t values (2000000000),(2000000000),(2000000000),(2000000000);

select sum(a) * 99 from t;

We get here :

+==============+
| sum(a) * 99  |
+==============+
| 792000000000 |
+--------------+