Paste / Convert BigInt to Varchar in MySQL

Question

How can I convert BigInt to Varchar in MySQL?

Answer 1

 mysql> select Cast (12345678901234567890 as char);
 + ------------------------------------- +
 |  Cast (12345678901234567890 as char) |
 + ------------------------------------- +
 |  12345678901234567890 | 
 + ------------------------------------- +

Answer 2

I think you cannot use varchar , try char instead. Or are you trying to change the type of an existing table field? Then you need to do, for example:

ALTER TABLE MODIFY COLUMN mycolumn varchar(50);