Casting varchar for int in mysql

Question

I have an air_id column, which is a varchar in the route of the table, now I want to copy this value to the air_id_int column, which is of type int. I cannot get the syntax correctly, though ..

This is what I have:

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

Answer 1

For CAST, you need to use the AS keyword .

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)

.

Answer 2

Try the following:

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

Cannot pass value directly int. If you need a signed int, replace UNSIGNEDwith 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

Answer 4

try it

update route set airline_id_int = CONVERT(airline_id, UNSIGNED);
update route set airline_id_int = CONVERT(airline_id, SIGNED);