MySQL Notes

1 | 2 | 3 | 4 | Index

The most prominent new feature of MySQL 4.1 is the introduction of subqueries (also known as subselects), a very welcome addition which brings MySQL's feature set a little closer to that of other databases.

Posted at 11:10 PM

It's possible to modify the way in which MySQL interprets certain parts of SQL, useful when porting queries from other databases. For example, the option PIPES_AS_CONCAT will persuade it to accept || as a concatenation operator rather than as a synonym for OR (see also gotcha 1.12). In 4.1 this facility has been extended considerably.

Posted at 9:52 PM

October 30, 2004

MySQL | MySQL 4.1 released

After a long testing period MySQL 4.1 has finally been declared production ready and is available for download. Representing a further incremental step in MySQL's steady advancement towards fully-fledged RDBMS-dom, it provides several sorely-missed features including sub-SELECTs.

Posted at 2:23 PM

October 25, 2004

MySQL | New forums at mysql.com

It looks like MySQL are moving their mailing lists to a forum-based solution, currently in beta-testing. Whether these will completely replace the lists, or provided an alternative web-based interface, isn't yet clear.

Posted at 8:40 PM

Having recently debugged a MySQL replication setup, I was having a hard time keeping track of which database was open in which mysql command line client, as since before the start of time the prompt has been a very terse  mysql> , giving no visual clue to which database is currently the default.

Fortunately, beginning with release 4.0.2 MySQL now provides a little-known option to set the prompt in a manner similar to that used in UNIX shells.

Posted at 9:07 AM

September 23, 2004


While browsing the online documentation I came across this snippet:

From MySQL 4.1.0, the attribute SERIAL can be used as an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. This is compatibility feature.
Posted at 10:06 PM

September 10, 2004

MySQL | --i-am-a-dummy

I thought it was a joke when I first heard about it, but the MySQL command line client has this option where you can actually tell it you're stupid:

 mysql --i-am-a-dummy -uroot test
Posted at 11:09 PM

1 | 2 | 3 | 4 | Index