Excel: Making Columns VARCHAR(12)
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!
Subject
Views
Written By
Posted
Excel: Making Columns VARCHAR(12)
1096
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.