MySQL Forums
Forum List  »  MySQL for Excel

Excel: Making Columns VARCHAR(12)
Posted by: Mark Robinson
Date: August 01, 2018 07:42PM

I'm exporting a large spreadsheet to mysql and coming up with an "too large" error that suggests I change my columns to Varchar(12). I can do this, one-by-one in the export screen, but as there are over 600 columns, this would take forever.

Currently, some of the columns are varchar(12), others are varchar(255) and I cant really see any good reason why. All the data is no more than a few characters or small values.

How can I perform an operation in excel that will cause all the columns to be varchar(12)?

Thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
Excel: Making Columns VARCHAR(12)
726
August 01, 2018 07:42PM


Sorry, you can't reply to this topic. It has been closed.

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.