Wednesday, September 3, 2014

babies

me: my contract agreement on this planet has no condition for either of those
though i might make babies to research random motion

D: or making your wife looks fat

me: you mean fatter than default setting for women?

D: I must admin there are plenty of uses of babies.  so dont be shy

me: having baby = shared admin = annoying
you will always be arguing about which package to install on the baby 
then one day baby will revoke your admin rights and then its back to base 0

Update with Select using Joins

Using a technique called Path Enumeration, we can arrange hierarchical menus, typically seen on shopping websites. Here's a query to quickly generate the path tree for menu items. Here, it is shown to build paths for children to parent nodes 4 and 6.

UPDATE ADJLIST A INNER JOIN
(
SELECT A1.id, CONCAT(A2.path,A1.id,'/') AS NEWPATH FROM ADJLIST A1
INNER JOIN (SELECT id, path FROM ADJLIST WHERE id IN (4,6)) A2
ON A1.parent_id = A2.id
) A3
ON A.id = A3.id
SET A.path=A3.newpath


See: 
http://stackoverflow.com/a/25328460/1330710
http://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
http://stackoverflow.com/questions/14815668/add-to-existing-value-in-mysql-column-using-concat-function
http://www.slideshare.net/billkarwin/models-for-hierarchical-data

Friday, July 4, 2014

maker fair revolution

https://events.webmaker.org/
http://www.whitehouse.gov/the-press-office/2014/06/18/fact-sheet-president-obama-host-first-ever-white-house-maker-faire

"America has always been a nation of tinkerers, inventors, and entrepreneurs. In recent years, a growing number of Americans have gained access to technologies such as 3D printers, laser cutters, easy-to-use design software, and desktop machine tools, with even more being created by the day. These tools are enabling more Americans to design and build almost anything.

New technologies for rapid prototyping – from laser cutters to CNC routers to 3D printers – have dramatically lowered the cost of developing a prototype and starting a business in manufacturing. The ability to rapidly and affordably test, tinker, monitor and customize places a premium on locating production close to American markets and opens new doors to entrepreneurship and innovation in manufacturing. The power of these emerging technologies creates the opportunity for Makers to launch new businesses, create jobs and build the industries of the future."


Ignorance isn't bliss.