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

Aecs

Options: ReplyQuote


Subject
Written By
Posted
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.