MySQL Server does not require you to specify name of the index if you're running ALTER TABLE statement - it is optional. Though what might be good practical reasons to specify the key name or omit ?

Things what you should be looking at is how MySQL names indexes automatically as well as what maintaining the indexes.

Lets first speak about naming. If you do not specify index name MySQL will name index by the first column of index created, if there is such index already it will add numeric suffix to it, for example:

PLAIN TEXT SQL:

1. mysql> CREATE TABLE t1(i int, j int);
2. Query OK, 0 rows affected (0.01 sec)
3.  
4. mysql> ALTER TABLE t1 ADD KEY(i,j);
5. Query OK, 0 rows affected (0.03 sec)
6. Records: 0  Duplicates: 0  Warnings: 0
7.  
8. mysql> ALTER TABLE t1 ADD KEY(i);
…

Spinn3r is hiring for an experienced Senior Systems Administrator with solid Linux and MySQL skills and a passion for building scalable and high performance infrastructure.

About Spinn3r:

Spinn3r is a licensed weblog crawler used by search engines, weblog analytic companies, and generally anyone who needs access to high quality weblog data.

We crawl the entire blogosphere in realtime, remove spam, rank, and classifying blogs, and provide this information to our customers.

Spinn3r is rare in the startup world in that we’re actually profitable. We’ve proven our business model which gives us a significant advantage in future product design and expanding our current customer base and feature set.

We’ve also been smart and haven’t raised a dime of external VC funding which gives us a lot …

So, Ray Ozzie has gone on the record to suggest that open source could be a bigger threat to Microsoft than Google is. Savio isn't buying that line, and I'm not sure that I do, either.

Let's be clear about what Ozzie actually said:

...[O]pen source [i]s much more potentially disruptive [than Google].

Open source has disruptive potential. Google is disruptive now. Google is making money now in markets that Microsoft covets, while open source is not cutting into a single Microsoft revenue stream. Not one. Red Hat and Novell's SUSE are almost entirely eating away at the Unix market, while MySQL is creating new markets with web properties. Open source? It doesn't (today) make a dent in Office, Windows, XBox, Dynamics, etc.

So why is …

Quick 'n' Easy LAMP Server For CentOS/RHEL

This tutorial shows a quick way of installing a LAMP server (Linux + Apache + MySQL + PHP/Perl together commonly known as LAMP Server.) on CentOS and RHEL server systems.

So, I was asked in IRC today about the proposed short array syntax for PHP. For those that don't know, I mean the same syntax that other languages (javascript, perl, python, ruby) all have. Currently in PHP we have this:

$var = array(1,2,3);

The proposed additional syntax is:

$var = [1,2,3];

So, I voted +1 for this feature on the PHP Internals list. A colleague asked me why I voted +1. At first I had no good answer other than it was just a gut feeling. It just feels like a good addition to the language. It is common among web languages and therefore users coming into PHP from other languages may find it more comfortable.

The best thing I could tell him was that it would make arrays fall in line with other data types in PHP. For example, you never write:

$var = int(1);

$var = string(foo);

So, why oh why do we have to have what …

More attention to this survey is coming from Lenz Grimmer MySQL Community Manager for EMEA, and …

Bug fixes:

*  OS monitoring issue in Fedora Core 6 Zod was fixed

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Within 36 hours of launching, the 2008 MySQL Magazine Survey has over 100 responses from around the globe. Join the community and let us know how you use MySQL.

Have you surveyed?

2008 MySQL Magazine SurveyMySQL DBA & Programming Blog by Mark Schoonover

Within 36 hours of launching, the 2008 MySQL Magazine Survey has over 100 responses from around the globe. Join the community and let us know how you use MySQL.

Have you surveyed?

2008 MySQL Magazine SurveyMySQL DBA & Programming Blog by Mark Schoonover