mysql: convert number to string

by prettyscripts on 2009-05-29 10:51:17

to copy value from a column in table a to a column in table b, the syntax is straight forward:

Code:

insert into new_table (new_column)
select old_column from old_table

but when new_column is varchar and old_column is integer, you will get an error.

you need to use cast function. update the above query as follows:

Code:

insert into new_table (new_column)
select cast(old_column as char) from old_table

Leave a comment

	`insert into new_table (new_column)`
	`select old_column from old_table`

	`insert into new_table (new_column)`
	`select cast(old_column as char) from old_table`