ma.gnolia

Sign In | Learn More

Skip to main content


14551_32 pyroman's Bookmarks Tagged With "syntax"

  1. 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. 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. 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. 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. Visit Multiple Inserts with a Subquery Multiple Inserts with a Subquery

    http://codespatter.com/2008/03/20/multiple-inserts-with-a-subquery/

    Important information on using a subquery when doing an insert.

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

XML Feed Publish or subscribe to pyroman's Bookmarks Tagged With "syntax" via RSS and more...

Print-icon-10x10 Print these bookmarks

byncsa Some rights reserved