JortK.nl
Mind farts of a crappy coder!
  • Home
  • Fok!Search
  • Fok! Maandcijfers
  • WP-Cleanup

db

The 20 best practices when using MySQL

By JortK on November 28, 2009

Just came across this great article with 20 best practices when using MySQL: MySQL best practices. Be sure to check them, the following items are in the article: Optimize Your Queries For the Query Cache LIMIT 1 When Getting a Unique Row Get Suggestions with PROCEDURE ANALYSE() Prepared Statements Split the Big DELETE or INSERT [...]

Posted in MySQL | Tagged best practices, cache, database, db, MySQL, query, select, show | Leave a response

Using TOP in MySQL queries

By JortK on June 26, 2009

On the web I see a lot of questions of developers who are wanting to know how they can retrieve only the first N records in their queries. The answer is simple, LIMIT For example, if you only want to select the top 5 names from a names tables, use the following query: SELECT `firstname`,`lastname` [...]

Posted in How to | Tagged database, db, limit, MySQL, query, rownum, top, trick | Leave a response

Categories

  • google
  • How to
  • microsoft
  • Movies
  • Music
  • MySQL
  • php
  • Pictures
  • RSS Reader Picks
  • seo
  • Site News
  • Tech news
  • twitter
  • Uncategorized
  • wordpress

Tags

ad ads adsense analytics android api apps blog browser buzz chrome css dance development docs funny gmail google hardstyle hiphop house jquery labs mail maps mobile movie Music MySQL photoshop php rap rss search seo social tip tutorial twitter video wave web development webinar wordpress youtube

Archives

  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • April 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008

Copyright © 2010 JortK.nl.

Powered by WordPress, Hybrid, and Structure.