Casting varchar to int in mysql

Question

I have a column airline_id which is varchar in the table route, now I want to copy that value into the column airline_id_int which has the type int. I can't get the syntax right though..

This is what I have:

UPDATE route SET airline_id_int = CAST(airline_id, int);

Answer 1

You have to use the AS keyword for CAST.

update route set airline_id_int = cast(airline_id AS UNSIGNED)

You can use

update route set airline_id_int = cast(airline_id AS SIGNED)

as well.

Answer 2

Try the following:

update route set airline_id_int = cast(airline_id AS UNSIGNED);

It's not possible to cast directly to int. If you need signed int, replace UNSIGNED with SIGNED.

Answer 3

update route set airline_id_int = cast(airline_id as signed);

or

update route set airline_id_int = cast(airline_id as unsigned);

if it can be negative