Skip to content

Instantly share code, notes, and snippets.

@dnaeon

dnaeon/gist:1116796

Created July 31, 2011 13:28
Show Gist options
  • Save dnaeon/1116796 to your computer and use it in GitHub Desktop.
Save dnaeon/1116796 to your computer and use it in GitHub Desktop.
Download ZIP
test sql
Raw
gistfile1.sql
SELECT rowid, origin, name, version, comment, desc, arch, arch, osversion, maintainer, www, flatsize, pkgsize, cksum, path, dbname FROM ( SELECT rowid, origin, name, version, comment, desc, arch, arch, osversion, maintainer, www, flatsize, pkgsize, cksum, path, 'dnaeon-test' AS dbname FROM 'dnaeon-test'.packages WHERE name LIKE ?1 UNION SELECT rowid, origin, name, version, comment, desc, arch, arch, osversion, maintainer, www, flatsize, pkgsize, cksum, path, 'dnaeon' AS dbname FROM 'dnaeon'.packages WHERE name LIKE ?1 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment