Scripting

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

Read More
Misc

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’ […]

Read More