sql-info.de

MySQL Notes

1 | 2 | 3 | 4 | Index

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 6: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 7:07 AM

September 23, 2004

MySQL | SERIAL

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 8: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 9:09 PM

1 | 2 | 3 | 4 | Index