A chronological documentation test project, nothing serious, really!

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 {} ;

Tags: ,

Posted by

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

Tags: , ,

Posted by