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) 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
