Holger Weis betawax

## gist:1063274
find . -name '._*' -exec rm -f {} \;

## gist:1063282
UPDATE table SET field = REPLACE(field, 'foo', 'bar');

## gist:1063285
SELECT field, COUNT(field) AS count FROM table GROUP BY field HAVING (count>1);

## gist:1063288
SELECT id, MAX(count) AS count FROM table GROUP BY id ORDER BY count;

## gist:1063292
(SELECT foo FROM table) UNION (SELECT bar FROM table) ORDER BY foobar;

## gist:1136849
SELECT SUBSTRING_INDEX(email, '@', -1) AS domain, COUNT(SUBSTRING_INDEX(email, '@', -1)) AS count FROM table GROUP BY domain ORDER BY count DESC;

## t3dump.sh
#!/bin/sh

# Project infos
PROJECT_NAME=foobar
DOCUMENT_ROOT=htdocs

# Database access
DB_USERNAME=foo
DB_PASSWORD=bar
DB_DATABASE=foobar

## gist:1760260
SELECT @rownum := @rownum + 1 AS row FROM foobar fb, (SELECT @rownum := 0) rn ORDER BY foobar;

## gist:1783404
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

## html4.html
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <title></title>
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <link rel="stylesheet" type="text/css" href="" />
</head>
	#!/bin/sh

	# Project infos
	PROJECT_NAME=foobar
	DOCUMENT_ROOT=htdocs

	# Database access
	DB_USERNAME=foo
	DB_PASSWORD=bar
	DB_DATABASE=foobar
	<?xml version="1.0" encoding="UTF-8" ?>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<title></title>
	<meta http-equiv="content-type" content="text/html; charset=utf-8" />
	<link rel="stylesheet" type="text/css" href="" />
	</head>