I am trying to run an alter query on a table, and its giving me a
Lost connection to MySQL server during query MySQL server has gone away.
The query that I am running is
alter table table_name modify column_name DOUBLE ( 16, 2) default 8.5;
I am guessing that the table contains a lot of data, and hence the alter is taking a lot of time, and the server connection is lost.
My query is,
How do I find out the amount of data present in the table ? ( in MB/GB i suppose).
Secondly, In case the table does contain a huge amount of data, then how do I perform the alter on this table ?