mysql: convert number to string

by prettyscripts on 2009-05-29 10:51:17 • Leave a comment »

miscsql

to copy value from a column in table a to a column in table b, the syntax is straight forward: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.… more »

Tags: convert, mysql, number, string