MySQL Forums
Forum List  »  General

export to csv - number <=> string issues
Posted by: Alexandre Salomé
Date: August 20, 2019 07:35PM

Is it possible put a prefix in a value during the command select?

example: select phone, icmd from tc_phone

As is:

phone icmd
012 1234567890
013 2345678901

To be (necessity to have "vendor1-" before ) :
phone icmd
012 vendor1-1234567890
013 vendor1-2345678901

All helps is appreciated


Options: ReplyQuote

Written By
export to csv - number <=> string issues
August 20, 2019 07:35PM

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.