Cast/Convert BigInt to Varchar in MySQL

Question

How might I Cast/Convert BigInt to Varchar in MySQL?

Answer 1

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

Answer 2

I think you can't cast to varchar, try char instead. Or are you trying to modify the type of an existing field of a table? Then you have to do for example:

ALTER TABLE MODIFY COLUMN mycolumn varchar(50);