Kent Johnson kentoj

## osx-setup.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                kentoj
                / osx-setup.md
            
            
              Last active
              August 29, 2015 14:08
                — forked from zenorocha/.hyper.js
            
          
    Setup Mac OS X

I'm in a hospital in Spain and my MacBook was stolen.

Now I bought a new one and need to configure it. I have an external hard drive that backup everything using Time Machine, but I don't want all the crap I had in the old one.
1. Run Software Update


## closure-table-operations.sql
-- Retrieve descendants
-- ====================
-- retrieve descendants of #4
SELECT c.*
  FROM Comments AS c
    JOIN TreePaths AS t ON c.comment_id = t.descendant
 WHERE t.ancestor = 4;


-- Retrieve ancestors
	-- Retrieve descendants
	-- ====================
	-- retrieve descendants of #4
	SELECT c.*
	FROM Comments AS c
	JOIN TreePaths AS t ON c.comment_id = t.descendant
	WHERE t.ancestor = 4;


	-- Retrieve ancestors