MySQL Reference Manual

Contributors to MySQL

While MySQL AB owns all copyrights in the MySQL server and the MySQL manual, we wish to recognise those who have made contributions of one kind or another to the MySQL distribution. Contributors are listed here, in somewhat random order:

Paul DuBois

Help with making the Reference Manual correct and understandable. That includes rewriting Monty’s and David’s attempts at English into English as other people know it.

Gianmassimo Vigazzola [e-mail] or [e-mail]

The initial port to Win32/NT.

Kim Aldale

Helped to rewrite Monty’s and David’s early attempts at English into English.

Per Eric Olsson

For more or less constructive criticism and real testing of the dynamic record format.

Irena Pancirov [e-mail]

Win32 port with Borland compiler. mysqlshutdown.exe and mysqlwatch.exe.

David J. Hughes

For the effort to make a shareware SQL database. At TcX, the predecessor of MySQL AB, we started with mSQL, but found that it couldn’t satisfy our purposes. So instead we wrote an SQL interface to our application builder Unireg. mysqladmin and mysql client are programs that were largely influenced by their mSQL counterparts. We have put a lot of effort into making the MySQL syntax a superset of mSQL. Many of the API’s ideas are borrowed from mSQL to make it easy to port free mSQL programs to the MySQL API. The MySQL software doesn’t contain any code from mSQL. Two files in the distribution (client/insert_test.c and client/select_test.c) are based on the corresponding (non-copyrighted) files in the mSQL distribution, but are modified as examples showing the changes necessary to convert code from mSQL to MySQL server. (mSQL is copyrighted by David J. Hughes.)

Fred Fish

For his excellent C debugging and trace library. Monty has made a number of smaller improvements to the library (speed and additional options).

Richard A. O’Keefe

For his public domain string library.

Henry Spencer

For his regex library, used in WHERE column REGEXP regexp.

Free Software Foundation

From whom we got an excellent compiler (gcc), the libc library (from which we have borrowed strto.c to get some code working in Linux), and the readline library (for the mysql client).

Free Software Foundation & The XEmacs development team

For a really great editor/environment used by almost everybody at MySQL AB/TcX/detron.

Patrick Lynch

For helping us acquire http://www.mysql.com/.

Fred Lindberg

For setting up qmail to handle the MySQL mailing list and for the incredible help we got in managing the MySQL mailing lists.

Igor Romanenko [e-mail]

mysqldump (previously msqldump, but ported and enhanced by Monty).

Yuri Dario

For keeping up and extending the MySQL OS/2 port.

Tim Bunce, Alligator Descartes

For the DBD (Perl) interface.

Tim Bunce

Author of mysqlhotcopy.

Andreas Koenig [e-mail]

For the Perl interface for MySQL server.

Eugene Chan [e-mail]

For porting PHP for MySQL server.

Michael J. Miller Jr. [e-mail]

For the first MySQL manual. And a lot of spelling/language fixes for the FAQ (that turned into the MySQL manual a long time ago).

Yan Cailin

First translator of the MySQL Reference Manual into simplified Chinese in early 2000 on which the Big5 and HK coded (http://mysql.hitstar.com/) versions were based. http://linuxdb.yeah.netPersonal home page at linuxdb.yeah.net.

Giovanni Maruzzelli [e-mail]

For porting iODBC (Unix ODBC).

Chris Provenzano

Portable user-level pthreads. From the copyright: This product includes software developed by Chris Provenzano, the University of California, Berkeley, and contributors. We are currently using version 1_60_beta6 patched by Monty (see mit-pthreads/Changes-mysql).

Xavier Leroy [e-mail]

The author of LinuxThreads (used by the MySQL server on Linux).

Zarko Mocnik [e-mail]

Sorting for Slovenian language and the cset.tar.gz module that makes it easier to add other character sets.

“TAMITO” [e-mail]

The _MB character set macros and the ujis and sjis character sets.

Joshua Chamas [e-mail]

Base for concurrent insert, extended date syntax, debugging on NT, and answering on the MySQL mailing list.

Yves Carlier [e-mail]

mysqlaccess, a program to show the access rights for a user.

Rhys Jones [e-mail] (and GWE Technologies Limited)

For the JDBC, a module to extract data from a MySQL database with a Java client.

Dr Xiaokun Kelvin ZHU [e-mail]

Further development of the JDBC driver and other MySQL-related Java tools.

James Cooper [e-mail]

For setting up a searchable mailing list archive at his site.

Rick Mehalick http://[e-mail]

For xmysql, a graphical X client for MySQL server.

Doug Sisk [e-mail]

For providing RPM packages of MySQL for RedHat Linux.

Diemand Alexander V. [e-mail]

For providing RPM packages of MySQL for RedHat Linux-Alpha.

Antoni Pamies Olive [e-mail]

For providing RPM versions of a lot of MySQL clients for Intel and SPARC.

Jay Bloodworth [e-mail]

For providing RPM versions for MySQL Version 3.21.

Jochen Wiedmann [e-mail]

For maintaining the Perl DBD::mysql module.

Therrien Gilbert [e-mail], Jean-Marc Pouyot [e-mail]

French error messages.

Petr snajdr, [e-mail]

Czech error messages.

Jaroslaw Lewandowski [e-mail]

Polish error messages.

Miguel Angel Fernandez Roiz

Spanish error messages.

Roy-Magne Mo [e-mail]

Norwegian error messages and testing of Version 3.21.#.

Timur I. Bakeyev [e-mail]

Russian error messages.

[e-mail] & Filippo Grassilli [e-mail]

Italian error messages.

Dirk Munzinger [e-mail]

German error messages.

Billik Stefan [e-mail]

Slovak error messages.

Stefan Saroiu [e-mail]

Romanian error messages.

Peter Feher

Hungarian error messages.

Roberto M. Serqueira

Portuguese error messages.

Carsten H. Pedersen

Danish error messages

David Sacerdote [e-mail]

Ideas for secure checking of DNS hostnames.

Wei-Jou Chen [e-mail]

Some support for Chinese (BIG5) characters.

Wei He [e-mail]

A lot of functionality for the Chinese (GBK) character set.

Zeev Suraski [e-mail]

FROM_UNIXTIME( ) time formatting, ENCRYPT( ) functions, and bison advisor. Active mailing list member.

Luuk de Boer [e-mail]

Ported (and extended) the benchmark suite to DBI/DBD. Has been of great help with crash-me and running benchmarks. Some new date functions. The mysql_setpermissions script.

Jay Flaherty [e-mail]

Big parts of the Perl DBI/DBD section in the manual.

Paul Southworth [e-mail], Ray Loyzaga [e-mail]

Proofreading the Reference Manual.

Alexis Mikhailov [e-mail]

User-definable functions (UDFs); CREATE FUNCTION and DROP FUNCTION.

Andreas F. Bobak [e-mail]

The AGGREGATE extension to UDF functions.

Ross Wakelin [e-mail]

Help to set up InstallShield for MySQL-Win32.

Jethro Wright III [e-mail]

The libmysql.dll library.

James Pereria [e-mail]

Mysqlmanager, a Win32 GUI tool for administrating MySQL server.

Curt Sampson [e-mail]

Porting of MIT-pthreads to NetBSD/Alpha and NetBSD 1.3/i386.

Antony T. Curtis [e-mail]

Porting of the MySQL database software to OS/2.

Martin Ramsch [e-mail]

Examples in the MySQL Tutorial.

Steve Harvey

For making mysqlaccess more secure.

Konark IA-64 Centre of Persistent Systems Private Limited

http://www.pspl.co.in/konark/. Help with the Win64 port of the MySQL server.

Albert Chin-A-Young.

Configure updates for Tru64, large file support and better TCP wrappers support.

John Birrell

Emulation of pthread_mutex( ) for OS/2.

Benjamin Pflugmann

Extended MERGE tables to handle INSERTS. Active member on the MySQL mailing lists.

Other contributors, bugfinders, and testers: James H. Thompson, Maurizio Menghini, Wojciech Tryc, Luca Berra, Zarko Mocnik, Wim Bonis, Elmar Haneke, jehamby@lightside, [e-mail], [e-mail], Ted Deppner [e-mail], Mike Simons, and Jaakko Hyvatti.

And lots of bug report/patches from the folks on the mailing list.

A big tribute goes to those who help us answer questions on the [e-mail] mailing list:

Daniel Koch [e-mail]

Irix setup.

Luuk de Boer [e-mail]

Benchmark questions.

Tim Sailer [e-mail]

DBD-mysql questions.

Boyd Lynn Gerber [e-mail]

SCO-related questions.

Richard Mehalick [e-mail]

xmysql-related questions and basic installation questions.

Zeev Suraski [e-mail]

Apache module configuration questions (log & auth), PHP-related questions, SQL syntax-related questions, and other general questions.

Francesc Guasch [e-mail]

General questions.

Jonathan J Smith [e-mail]

Questions pertaining to OS specifics with Linux, SQL syntax, and other things that might need some work.

David Sklar [e-mail]

Using MySQL from PHP and Perl.

Alistair MacDonald [e-mail]

Not yet specified, but is flexible and can handle Linux and maybe HP-UX. Will try to get user to use mysqlbug.

John Lyon [e-mail]

Questions about installing MySQL on Linux systems, using either .rpm files or compiling from source.

Lorvid Ltd. [e-mail]

Simple billing/license/support/copyright issues.

Patrick Sherrill [e-mail]

ODBC and VisualC++ interface questions.

Randy Harmon [e-mail]

DBD, Linux, some SQL syntax questions.