15 Sep 2009 chmod only files or folders
This post is just a personal note on how to chmod files or directories recursively
Recursive chmod only files within this folder
find . -type f -exec chmod 0600 {} ;
Recursive chmod only folders within this folder
find . -type d -exec chmod 0755 {} ;
Posted by Hans-Henry Jakobsen
06 Sep 2009 Howto combine two columns into one in mysql
This is how you can combine (or concatenate or merge) data from two table columns into one column using a mysql SQL query.
SELECT CONCAT(firstname,lastname) AS 'name' FROM tablename
The result would be “firstname lastname”
If you would like to insert this data into a new column
INSERT INTO tablename (full_name) SELECT CONCAT(firstname,lastname) AS 'name' FROM tablename
Posted by Hans-Henry Jakobsen
