Sql

An approach to make tree-based queries in SQL

http://dirtsimple.org/2010/11/simplest-way-to-do-tree-based-queries.html

Also consider Materialized path

UPDATE statement

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

http://www.w3schools.com/sql/sql_update.asp

DELETE statement

DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'

http://www.w3schools.com/sql/sql_delete.asp

Last edited by Artem Dudarev, 2013-10-13 02:01:37. Edit