Items

• Bookmark

  Conditions on Count or Sum in MySQL | Code Spatter

  Conditions on Count or Sum in MySQL

  Greg added 16 months ago

  • SHARE 
    1. Share with another Twine
    2. Share via Email
    3. Tweet This
  • VIEW COMMENTS 0
  • VIEW WEB PAGE
• Bookmark

  Tips for MySQL to PostgreSQL Switch

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

  Greg added 17 months ago

  • SHARE 
    1. Share with another Twine
    2. Share via Email
    3. Tweet This
  • VIEW COMMENTS 0
  • VIEW WEB PAGE
• Bookmark

  MySQL v PostgreSQL: Which have you used and why?

  Interesting discussion of developers experiences and comparisons.

  Greg added 18 months ago

  • SHARE 
    1. Share with another Twine
    2. Share via Email
    3. Tweet This
  • VIEW COMMENTS 0
  • VIEW WEB PAGE
• Bookmark

  How To Use Triggers to Track Changes in MySQL | Code Spatter

  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

  Greg added 19 months ago

  • SHARE 
    1. Share with another Twine
    2. Share via Email
    3. Tweet This
  • VIEW COMMENTS 0
  • VIEW WEB PAGE
• Bookmark

  Mr. Rosenblatt: The Blog » Insert where not exists

  If you want to insert values into a MySQL table, but only if those values don’t already exist, and you don’t want to use a primary key on the table (and deal with the resulting error suppression ), here’s an elegant one-query method of doing so. INSERT INTO [table name] SELECT '[value1]', ...

  Greg added 19 months ago

  • SHARE 
    1. Share with another Twine
    2. Share via Email
    3. Tweet This
  • VIEW COMMENTS 0
  • VIEW WEB PAGE