ma.gnolia

Sign In | Learn More

Skip to main content


3593_32 Recent Bookmarks in CodeGrrl Tagged With "sql"

  1. 14551_32

    Visit Conditions on Count or Sum in MySQL Conditions on Count or Sum in MySQL

    http://codespatter.com/2008/07/22/conditions-on-count-or-sum-in-mysql/

    When selecting count, sum, or some other aggregate function, the value isn’t determined until after the WHERE clause so a condition can’t be placed there.

  2. 14551_32

    Visit Tips for MySQL to PostgreSQL Switch Tips for MySQL to PostgreSQL Switch

    http://codespatter.com/2008/07/02/tips-for-mysql-to-postgresql-switch/

    If you’ve decided to move a few tables from MySQL to PostgreSQL, these few tips might help.

  3. 14551_32

    Visit How To Use Triggers to Track Changes in MySQL How To Use Triggers to Track Changes in MySQL

    http://codespatter.com/2008/05/06/how-to-use-triggers-to-track-changes-in-mysql/

    Setting constraints and rules in the database is better than writing special code to handle the same task since it will prevent another developer from writing a different query that bypasses all of the special code and could leave your database wi… More

  4. 14551_32

    Visit Swap Insert for Update When Key Exists Swap Insert for Update When Key Exists

    http://codespatter.com/2008/04/30/swap-insert-for-update-when-key-exists/

    When synchronizing tables or databases, sometimes it is useful to have a way to update a row if there is already an entry for a key. Using the MySQL syntax, ON DUPLICATE KEY UPDATE, it is possible to insert a row if it doesn’t exist or update it i… More

  5. 14551_32

    Visit How to Break a MySQL Left Join How to Break a MySQL Left Join

    http://codespatter.com/2008/02/19/how-to-break-a-mysql-left-join/

    Information on how to properly use conditional statements when using a Left Join.

Didn't find what you were looking for? Try searching Google.

XML Feed Publish or subscribe to Bookmarks in CodeGrrl Tagged With "sql" via RSS and more...

Print-icon-10x10 Print these bookmarks