Snipplr http://snipplr.com/favorites/brent-man/language/sql Recent snippets posted on Snipplr.com en-us Tue, 21 May 2013 18:03:29 GMT (SQL) select count - brent-man http://snipplr.com/view/11070/select-count/

]]> Sun, 11 Jan 2009 05:48:32 GMT http://snipplr.com/view/11070/select-count/ (SQL) Update from select - brent-man http://snipplr.com/view/5150/update-from-select/

]]> Thu, 21 Feb 2008 11:56:51 GMT http://snipplr.com/view/5150/update-from-select/ (SQL) Update Select - brent-man http://snipplr.com/view/4181/update-select/ Update one table by selecting from another. Avoids cursors.

]]> Fri, 23 Nov 2007 07:27:28 GMT http://snipplr.com/view/4181/update-select/ (SQL) MySQL Replace function - brent-man http://snipplr.com/view/2992/mysql-replace-function/ A life-saver in an emergency, to do a search & replace directly on the database. Probably also a cause of aforementioned emergency for many people, so do have a backup ready for when it goes wrong.

]]> Fri, 22 Jun 2007 07:19:41 GMT http://snipplr.com/view/2992/mysql-replace-function/