MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Drop column of big table
Posted by: Adrián García Castro
Date: October 21, 2023 01:52PM

I have a really big table (4 billion records).

I want to drop one column but its taking hours and still running.

Any advice/tip on how to drop the column faster? The column has only NULL values.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Drop column of big table
Adrián García Castro
October 21, 2023 01:52PM
Re: Drop column of big table
Zach Ellis
October 21, 2023 07:35PM
Re: Drop column of big table
Adrián García Castro
October 21, 2023 08:22PM
Re: Drop column of big table
Zach Ellis
October 21, 2023 09:01PM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.