ma.gnolia

Sign In | Learn More

Skip to main content


3593_32 Recent Bookmarks in CodeGrrl Tagged With "syntax"

  1. 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.

  2. 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

  3. 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

  4. 14551_32

    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 Bookmarks in CodeGrrl Tagged With "syntax" via RSS and more...

Print-icon-10x10 Print these bookmarks