MySQL Forums
Forum List  »  Newbie

Re: How To Alter Table Column To Add Two Column
Posted by: Rick James
Date: June 08, 2014 03:54PM

No such feature exists.

Instead, put the two pieces together when you query the table:

SELECT CONCAT(prefix, sno) AS id, ... FROM table_name ...

Options: ReplyQuote


Subject
Written By
Posted
Re: How To Alter Table Column To Add Two Column
June 08, 2014 03:54PM


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.