Common MySQL Queries Common MySQL Queries Basic aggregation Last updated 05 Jan 2013 Aggregate across columns Last updated 09 Sep 2009 Aggregates across multiple joins Given a parent table and two child tables, a query which sums values in both child tables, grouping on a parent table column, returns sums that are exactly twice as large as they should be. CREATE TABLE packageCredit ( packageCreditID INT, packageCreditItemID INT, Last updated 22 Feb 2013 Aggregates excluding leaders You have a table of grouped ranks ... Last updated 21 May 2009 Aggregates of specified size Find the values of a table column c1 for which there are a specified number of listed values in another column c2. All X for which all Y are Z You have an election database with tables for candidates, parties and districts. CREATE TABLE districts ( district char(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO districts VALUES ('Essex'),('Malton'),('Riverdale'),('Guelph'),('Halton'); All X meeting multi-row conditions 1. 2. Median
The Cathedral and the Bazaar Copyright © 2000 Eric S. Raymond Copyright Permission is granted to copy, distribute and/or modify this document under the terms of the Open Publication License, version 2.0. $Date: 2002/08/02 09:02:14 $ Abstract I anatomize a successful open-source project, fetchmail, that was run as a deliberate test of the surprising theories about software engineering suggested by the history of Linux. Short, Self Contained, Correct Example Short, Self Contained, Correct (Compilable), Example If you are having a problem with some code and seeking help, preparing a Short, Self Contained, Correct Example (SSCCE) is very useful. But what is an SSCCE? It is all in the name, really. Short (Small) - Minimise bandwidth for your example, do not bore the audience.Self Contained - Ensure everything is included, ready to go.Correct - Copy, paste, (compile,) see is the aim.Example - Displays the problem you are trying to solve. Short This depends on the group or forum. Tricks for Trimming If your GUI has 40 buttons not related to the problem, remove them. The array or table that is causing a problem may have a hundred entries, but again, if the problem can be seen with two or three entries, trim your example to that alone. If your problem is a GUI layout problem, trim all the processes (JavaScript/Java methods etc.) from behind it. Problem Solved? Self Contained You are much more likely to receive help if you do this. Correct Further tips:
The Object Oriented Life Projects / Users All the projects on this page use or have used Valgrind, eg. Firefox, OpenOffice, StarOffice, AbiWord, Opera, KDE, GNOME, Qt, libstdc++, MySQL, PostgreSQL, Perl, Python, PHP, Samba, RenderMan, Nasa Mars Lander software, SAS, The GIMP, Ogg Vorbis, Unreal Tournament, Medal of Honour... Contact valgrind@valgrind.org if you are happy to have your project added to this list. Please provide a URL and a short description of your project. Research Valgrind has been used as the starting point for various research projects. RISE: this University of New Mexico project used Valgrind to implement randomized instruction set emulation, in order to disrupt binary code injection attacks. Office Software OpenOffice: an open source multi-platform office productivity suite. Web Browsers Mozilla: web application suite, for browsing, email, IRC chat and HTML editing. Databases and Search Engines MySQL: the World's most popular open source database. Scientific Graphics and Visualization Simulation Development Tools
Top 10 best practices for front-end web developers Explain which div you’re closing Most of the time when I’m viewing a website source, I see, at the very bottom of the page, an almost endless list of closing </div> tags. In fact, many beginners think they just have to use divs instead of tables to produce quality code. Divs are cleaners than tables, but without proper code organization, it can be as (or even sometimes more) messy as table based code. Using indentation is a good start. <div id="header"><div id="sub" class="first left"> ... Use a CSS reset Unless you’re a beginner or if you were on vacation on a desert island for the last 6 years, you might already know how useful a CSS reset it. Source: Don’t use @import CSS files can be included using the @import directive. <style type="text/css> @import url('a.css'); @import url('b.css'); </style> While it works, the @import directive is much slower than the other way to include stylesheets into a html document: “Smush” your images ...
The SELECT .. JOIN statement Sometimes you need to access two or more tables to get the data required. schema:scott DROP TABLE games; DROP TABLE city CREATE TABLE games( yr INTEGER, city VARCHAR(20)); INSERT INTO games VALUES (1896,'Athens'); INSERT INTO games VALUES (1948,'London'); INSERT INTO games VALUES (2004,'Athens'); INSERT INTO games VALUES (2008,'Beijing'); INSERT INTO games VALUES (2012,'London'); CREATE TABLE city ( name VARCHAR(20), country VARCHAR(20)); INSERT INTO city VALUES ('Sydney','Australia'); INSERT INTO city VALUES ('Athens','Greece'); INSERT INTO city VALUES ('Beijing','China'); INSERT INTO city VALUES ('London','UK'); You can use a JOIN to get results from two or more related tables. SELECT games.yr, city.country FROM scott.games JOIN scott.city ON (games.city = city.name) SELECT games.yr, city.country FROM games JOIN city ON (games.city = city.name) result There are variations oracle See also
Version Control by Example Digital Browse it online PDF downloads US Letter (226 pages) A4 (210 pages) EPUB (most e-book readers except Kindle) Kindle (hopefully coming soon) Print Buy the print edition on Amazon Request a free copy Praise "Version Control by Example may as well be called The Hitchhiker's Guide to Distributed Version Control -- it's a concise and informative compendium that serves as both an introduction and a manual for practical usage of Mercurial, Git, Veracity, and virtually any other version control system." Alex Papadimoulis The Daily WTF "Eric covers multiple tools in lighthearted style that makes a potentially dry subject both amusing and understandable. Ben Collins-Sussman Apache Subversion Developer "Version control is a critical tool in the developer's tool chain. C. "Apache Subversion's rise to popularity opened the floodgates for others to explore new features and designs in version control, the most popular being Distributed Version Control Systems (DVCS). More...
About uPortal uPortal is the leading open source enterprise portal framework built by and for the higher education community. uPortal continues to evolve through contributions from its global community and is supported by resources, grants, donations, and memberships fees from academic institutions, commercial affiliates, and non-profit foundations. uPortal is built on open standards-based technologies such as Java and XML, and enables easy, standards-based integration with authentication and security infrastructures, single sign-on secure access, campus applications, web-based content, and end user customization. uPortal can easily integrate with other enterprise systems and can be customized for specific local needs. The powerful layout management system enables a dynamic, personal view for users with multiple roles. For information on the many portlets available for uPortal, see Portlets. uPortal is mobile-ready for a wide variety of mobile devices! Forever Free!
Ubuntu Linux - Tips and Tricks in using Ubuntu Ubuntu Linux - Tips and Tricks in using Ubuntu - Tutorial Copyright © 2008, 2009, 2010, 2011, 2012, 2013 Lars Vogel Ubuntu - Typical Tasks This articles contains some information about handling a Ubuntu system. Ubuntu Linux is a full fledged Linux system trailed for the desktop. Unity is the default windows manager on Ubuntu. Press the Windows key to start the Dash. 2.2. To add new entries to the launcher you can create an .desktop file and drag file on the launcher. The following lists a few useful shortcuts for the Unity window manager. Table 1. To open a console open the Dash and type in Terminal. Ubuntu offers several editors which are installed by default. To install vim on your Ubuntu machine use the following command. sudo apt-get install vim Start vim from the command line. vim has two modes, one editing mode and other mode in which you can move within the file. A simple editor with a graphical user interface is gedit. The following demonstrates the usage of the find command. Table 2.
Media From Wikipedia, the free encyclopedia Media may refer to: Communications[edit] Computing[edit] Fine art[edit] Life sciences[edit] Growth medium, objects in which microorganisms or cells can experience growthMedia filter, a filter consisting of several different filter materialsTunica media, the middle layer of the wall of a blood vesselA group of insect wing veins in the Comstock-Needham system Locations[edit] Music[edit] Phonology[edit] Traditional name of Voiced stop Ships[edit]
TeX Frequently Asked Questions This is a set of Frequently Asked Questions (FAQ) for English-speaking users of TeX. The questions answered here cover a wide range of topics, but typesetting issues are mostly covered from the viewpoint of a LaTeX user. Some of the questions answered have little relevance to today’s users; this is inevitable — it’s easier to add information than it is to decide that information is no longer needed. The set of answered questions is therefore in a state of slow flux: new questions are answered, while old questions are deleted … but the whole process depends on the time available for FAQ maintenance. \noindent You may use the FAQ by reading a printed document, by viewing a PDF file, with hyperlinks to assist browsing: copies are available formatted so that they could be printed on A4 paper or on North American “letter” paper, or via Scott Pakin’s Visual FAQ, which shows LaTeX constructions with links to FAQ explanations of how they may be created.