I am creating new table from existing table using select query. The existing table column having data type varchar(255) so in newly created table that column contains varchar data type as default.

Now how to change new table column to other data type TEXT. here is the mysql query. Tried cast() and convert() but didn't work for TEXT data type

```
CREATE TABLE topper  AS
SELECT studentname as `Name`, rollno as `Roll_No`, description as `Information`
FROM student

```

I want 'Information' column in TEXT data type.

Thanks for any help.