MySQL Forums
Forum List  »  Newbie

Outfile - stop padding of columns
Posted by: Mike Lambert
Date: April 05, 2019 03:14AM

Hi,

I want to write an outfile comprising of Surname and First name as a csv file.

Each column is 40 bytes ... but really there is only 2 bytes per column. How do I write only 2 columns of 2 bytes and not 2 columns of 40 bytes. Currently the columns are padded out to the column length as defined in the table... 40 bytes each.

Thks,

Mike

Options: ReplyQuote


Subject
Written By
Posted
Outfile - stop padding of columns
April 05, 2019 03:14AM


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.