mysql: convert number to string

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

misc • sql

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

convert file format for dos and unix

by prettyscripts on 2008-01-03 11:55:20 • Leave a comment »

unix

most of my development works are done on linux/unix. i use / evaluate a lot of open source projects and some files has ^M when edited from this platform. this is because the file was saved in dos format which uses a different EOL (end of line character).… more »

Tags: convert, dos, eol, unix