Posts in: MySQL / Databases

NYPHP Con: “Maximum Velocity MySQL” – Optimization and coding tips

With Jay Pipes of MySQL. Jay Pipes is the Community Relations Manager, North America for MySQL, Inc. This was a three-hour tutorial about ways to fine-tune your MySQL queries. This is part two of my notes. This post may contain inaccuracies, typos, boo-boos, etc. Jay says his slides will be available on his web site, [...] [14 Jun 2006]

NYPHP Con: “Maximum Velocity MySQL” – Indexes and storage engines

With Jay Pipes of MySQL. Diversity stats, in case you’re wondering: Men: about 30. Women: 4. People of color: 4. Jay Pipes is the Community Relations Manager, North America for MySQL, Inc. This was a three-hour tutorial about ways to fine-tune your MySQL queries. This is part one of my notes. This post may contain [...] [14 Jun 2006]

One more way to use COUNT(*)

Gavin adds a way to make your COUNT(*) query just a little bit cleaner for use in PHP: SELECT field_name, COUNT(*) AS total FROM table_name WHERE id > 3 GROUP BY field_name ORDER BY total ASC; The ‘AS total’ bit is a big deal because now COUNT(*) will become a key named ‘total’ in the [...] [10 Mar 2005]

Firefox Google searches, Gmail Atom feeds, and COUNT(*)-ing stuff in MySQL

I found out by accident that you can do a Google “I’m Feeling Lucky” search right from the Firefox address bar. This is not the same as the search box to the right of the address bar.I’m talking about the same place where you type a URI to visit a site. Type in your search [...] [8 Mar 2005]

My S Q L CONCAT() function

I’m building the back-end for JAWS.org, which will ?¢‚Ǩ‚Äù among other things ?¢‚Ǩ‚Äù allow members to search for other members by name. I wanted users to be able to search whole names (such as “Tiffany Brown”). But I couldn’t figure out how. Here’s a query similar to the original: SELECT * FROM membership WHERE firstName [...] [6 Oct 2003]

Forms, arrays PHP and databases

For the last two days, I have been pulling my hair out (not literally) about this problem: How to store array data in a database. I solved the problem and learned something to boot. Read what I learned. [7 Sep 2003]

S Q L Training on a budget

Want to get your feet wet with SQL? Try SQLCourse.com. [25 Aug 2003]

An article to live by

It’s an oldie, but a goodie: SQL Injection Attacks: Are You Safe? from DevArticles.com. If you develop with databases, you should definitely read this article. It focuses on ASP and Microsoft SQL Server 2000, but the concepts are similar across other databases, including MySQL and Oracle 9i. Quick PHP tip: If you use numbers in [...] [24 Aug 2003]

If you can’t fix one problem…

…fix another instead. Namely, the date issue. The old ‘posted on:’ format was a raw, unformatted MySQL date. It did the job, but it was a little bit awkard because of its ‘YYYY-MM-DD’ format. What I wanted instead was a pretty, text date: ‘day, month date, year.’ But whenever I tried to convert the numeric [...] [11 Aug 2003]