Preface, Notes, Licenses

Table of Contents

1. MySQL Copyright Notice
2. regex Library License
3. libedit License
4. Netlib License
5. Unicode Terms of Use

This is the Reference Manual for the MySQL Database System, version 6.0, through release 6.0.12. It is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 6.0 and previous versions. If you are using an earlier release of the MySQL software, please refer to the MySQL 5.1 Reference Manual, which covers the 5.1 series of MySQL software releases, MySQL 5.0 Manual, which covers MySQL 5.0 releases, or to MySQL 3.23, 4.0, 4.1 Reference Manual, which covers the 3.23, 4.0, and 4.1 series of MySQL software releases. Differences between minor versions of MySQL 6.0 are noted in the present text with reference to release numbers (6.0.x).

MySQL and the Reference Manual are covered under the copyrights given in Section 1, “MySQL Copyright Notice”.

The following is a list of the creators of the libraries we have included with the MySQL server source to make it easy to compile and install MySQL. We are thankful to all individuals that have created these. Some of these libraries require that their licensing terms be included in the documentation of products that include them. Cross references to these licensing terms are given with the applicable items in the list.

1. MySQL Copyright Notice

Copyright © 2005-2008 MySQL AB, 2009 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, U.S.A. All rights reserved. U.S. Government Rights - Commercial software. Government users are subject to the Sun Microsystems, Inc. standard license agreement and applicable provisions of the FAR and its supplements. Sun, Sun Microsystems, the Sun logo, Java, Solaris, StarOffice, MySQL and MySQL logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. UNIX is a registered trademark in the U.S. and other countries, exclusively licensed through X/Open Company, Ltd. Products covered by and information contained in this service manual are controlled by U.S. Export Control laws and may be subject to the export or import laws in other countries. Nuclear, missile, chemical biological weapons or nuclear maritime end uses or end users, whether direct or indirect, are strictly prohibited. Export or reexport to countries subject to U.S. embargo or to entities identified on U.S. export exclusion lists, including, but not limited to, the denied persons and specially designated nationals lists is strictly prohibited. DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID.

Copyright © 2005-2008 MySQL AB, 2009 Sun Microsystems, Inc., 4150 Network Circle, Santa Clara, California 95054, Etats-Unis. Tous droits réservés. Sun, Sun Microsystems, le logo Sun, Java, Solaris, StarOffice, MySQL et MySQL logo sont des marques de fabrique ou des marques déposées de Sun Microsystems, Inc. aux Etats-Unis et dans d'autres pays. UNIX est une marque déposée aux Etats-Unis et dans d'autres pays et licenciée exlusivement par X/Open Company, Ltd. Les produits qui font l'objet de ce manuel d'entretien et les informations qu'il contient sont regis par la legislation americaine en matiere de controle des exportations et peuvent etre soumis au droit d'autres pays dans le domaine des exportations et importations. Les utilisations finales, ou utilisateurs finaux, pour des armes nucleaires, des missiles, des armes biologiques et chimiques ou du nucleaire maritime, directement ou indirectement, sont strictement interdites. Les exportations ou reexportations vers des pays sous embargo des Etats-Unis, ou vers des entites figurant sur les listes d'exclusion d'exportation americaines, y compris, mais de maniere non exclusive, la liste de personnes qui font objet d'un ordre de ne pas participer, d'une facon directe ou indirecte, aux exportations des produits ou des services qui sont regi par la legislation americaine en matiere de controle des exportations et la liste de ressortissants specifiquement designes, sont rigoureusement interdites. LA DOCUMENTATION EST FOURNIE "EN L'ETAT" ET TOUTES AUTRES CONDITIONS, DECLARATIONS ET GARANTIES EXPRESSES OU TACITES SONT FORMELLEMENT EXCLUES, DANS LA MESURE AUTORISEE PAR LA LOI APPLICABLE, Y COMPRIS NOTAMMENT TOUTE GARANTIE IMPLICITE RELATIVE A LA QUALITE MARCHANDE, A L'APTITUDE A UNE UTILISATION PARTICULIERE OU A L'ABSENCE DE CONTREFACON.

This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how Sun disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of Sun Microsystems, Inc. Sun Microsystems, Inc. and MySQL AB reserve any and all rights to this documentation not expressly granted above.

2. regex Library License

The regex library used for the REGEXP operator is covered by this license:

Copyright 1992, 1993, 1994 Henry Spencer.  All rights reserved.
This software is not subject to any license of the American Telephone
and Telegraph Company or of the Regents of the University of California.

Permission is granted to anyone to use this software for any purpose on
any computer system, and to alter it and redistribute it, subject
to the following restrictions:

1. The author is not responsible for the consequences of use of this
   software, no matter how awful, even if they arise from flaws in it.

2. The origin of this software must not be misrepresented, either by
   explicit claim or by omission.  Since few users ever read sources,
   credits must appear in the documentation.

3. Altered versions must be plainly marked as such, and must not be
   misrepresented as being the original software.  Since few users
   ever read sources, credits must appear in the documentation.

4. This notice may not be removed or altered.

3. libedit License

Each file in the libedit library is covered by one of the following three licenses:

/*-
 * Copyright (c) 1992, 1993
 *	The Regents of the University of California.  All rights reserved.
 *
 * This code is derived from software contributed to Berkeley by
 * Christos Zoulas of Cornell University.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in the
 *    documentation and/or other materials provided with the distribution.
 * 3. Neither the name of the University nor the names of its contributors
 *    may be used to endorse or promote products derived from this software
 *    without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED.  IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
 * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
 * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
 * OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
 * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
 * OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 * SUCH DAMAGE.
 */
/*-
 * Copyright (c) 1997 The NetBSD Foundation, Inc.
 * All rights reserved.
 *
 * This code is derived from software contributed to The NetBSD Foundation
 * by Jaromir Dolecek.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in the
 *    documentation and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE NETBSD FOUNDATION, INC. AND CONTRIBUTORS
 * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
 * TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE FOUNDATION OR CONTRIBUTORS
 * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */
/*-
 * Copyright (c) 2001 The NetBSD Foundation, Inc.
 * All rights reserved.
 *
 * This code is derived from software contributed to The NetBSD Foundation
 * by Anthony Mallet.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in the
 *    documentation and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE NETBSD FOUNDATION, INC. AND CONTRIBUTORS
 * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
 * TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE FOUNDATION OR CONTRIBUTORS
 * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

4. Netlib License

MySQL incorporates work covered by the following copyright and permission notice:

The author of this software is David M. Gay.

Copyright (c) 1991, 2000, 2001 by Lucent Technologies.

Permission to use, copy, modify, and distribute this software for any
purpose without fee is hereby granted, provided that this entire notice
is included in all copies of any software which is or includes a copy
or modification of this software and in all copies of the supporting
documentation for such software.

THIS SOFTWARE IS BEING PROVIDED "AS IS", WITHOUT ANY EXPRESS OR IMPLIED
WARRANTY.  IN PARTICULAR, NEITHER THE AUTHOR NOR LUCENT MAKES ANY
REPRESENTATION OR WARRANTY OF ANY KIND CONCERNING THE MERCHANTABILITY
OF THIS SOFTWARE OR ITS FITNESS FOR ANY PARTICULAR PURPOSE.

5. Unicode Terms of Use

             Unicode Terms of Use
For the general privacy policy governing access to this
site, see the Unicode Privacy Policy. For trademark
usage, see the Unicode Consortium® Trademarks and
Logo Policy.

   A. Unicode Copyright.
      1. Copyright © 1991-2008 Unicode, Inc.
        All rights reserved.
      2. Certain documents and files on this
        website contain a legend indicating that
        "Modification is permitted." Any person
        is hereby authorized, without fee, to modify
        such documents and files to create derivative
        works conforming to the Unicode© Standard,
        subject to Terms and Conditions herein.
      3. Any person is hereby authorized, without fee, to
        view, use, reproduce, and distribute all
        documents and files solely for informational
        purposes in the creation of products
        supporting the Unicode Standard, subject to
        the Terms and Conditions herein.
      4. Further specifications of rights and restrictions
        pertaining to the use of the particular set of
        data files known as the "Unicode Character
        Database" can be found in Exhibit 1.
      5. Each version of the Unicode Standard has
        further specifications of rights and restrictions
        of use. For the book editions, these are found
        on the back of the title page. For the online
        edition, certain files (such as the PDF files for
        book chapters and code charts) carry specific
        restrictions. All other files are covered under
        these general Terms of Use. To request a
        permission to reproduce any part of the
        Unicode Standard, please contact the Unicode
        Consortium.
      6. No license is granted to "mirror" the Unicode
        website where a fee is charged for access to
        the "mirror" site.
      7. Modification is not permitted with respect to this
        document. All copies of this document must be
        verbatim.

B. Restricted Rights Legend. Any technical data or
   software which is licensed to the United States of
   America, its agencies and/or instrumentalities under
   this Agreement is commercial technical data or
   commercial computer software developed
   exclusively at private expense as defined in
   FAR 2.101, or DFARS 252.227-7014 (June 1995), as
   applicable. For technical data, use, duplication, or
   disclosure by the Government is subject to
   restrictions as set forth in DFARS 202.227-7015
   Technical Data, Commercial and Items (Nov 1995)
   and this Agreement. For Software, in accordance
   with FAR 12-212 or DFARS 227-7202, as applicable,
   use, duplication or disclosure by the Government is
   subject to the restrictions set forth in this Agreement.

C. Warranties and Disclaimers.
      1. This publication and/or website may include
        technical or typographical errors or other
        inaccuracies . Changes are periodically added
        to the information herein; these changes will
        be incorporated in new editions of the
        publication and/or website. Unicode may make
        improvements and/or changes in the
        product(s) and/or program(s) described in this
        publication and/or website at any time.
      2. If this file has been purchased on magnetic or
        optical media from Unicode, Inc. the sole and
        exclusive remedy for any claim will be
        exchange of the defective media within ninety
        (90) days of original purchase.
      3. EXCEPT AS PROVIDED IN SECTION C.2, THIS
        PUBLICATION AND/OR SOFTWARE IS
        PROVIDED "AS IS" WITHOUT WARRANTY OF
        ANY KIND EITHER EXPRESS, IMPLIED, OR
        STATUTORY, INCLUDING, BUT NOT LIMITED
        TO, ANY WARRANTIES OF
        MERCHANTABILITY, FITNESS FOR A
        PARTICULAR PURPOSE, OR
        NON-INFRINGEMENT. UNICODE AND ITS
        LICENSORS ASSUME NO RESPONSIBILITY
        FOR ERRORS OR OMISSIONS IN THIS
        PUBLICATION AND/OR SOFTWARE OR
        OTHER DOCUMENTS WHICH ARE
        REFERENCED BY OR LINKED TO THIS
        PUBLICATION OR THE UNICODE WEBSITE.

D. Waiver of Damages. In no event shall Unicode or its
   licensors be liable for any special, incidental, indirect
   or consequential damages of any kind, or any
   damages whatsoever, whether or not Unicode was
   advised of the possibility of the damage, including,
   without limitation, those resulting from the following:
   loss of use, data or profits, in connection with the
   use, modification or distribution of this information or
   its derivatives.

E. Trademarks.
    1. Unicode and the Unicode logo are registered
      trademarks of Unicode, Inc.
    2. This site contains product names and
      corporate names of other companies. All
      product names and company names and
      logos mentioned herein are the trademarks or
      registered trademarks of their respective
      owners. Other products and corporate names
      mentioned herein which are trademarks of a
      third party are used only for explanation and for
      the owners' benefit and with no intent to
      infringe.
    3. Use of third party products or information
      referred to herein is at the user's risk.

F. Miscellaneous.
    1. Jurisdiction and Venue. This server is operated
      from a location in the State of California, United
      States of America. Unicode makes no
      representation that the materials are
      appropriate for use in other locations. If you
      access this server from other locations, you are
      responsible for compliance with local laws.
      This Agreement, all use of this site and any
      claims and damages resulting from use of this
      site are governed solely by the laws of the State
      of California without regard to any principles
      which would apply the laws of a different
      jurisdiction. The user agrees that any disputes
      regarding this site shall be resolved solely in
      the courts located in Santa Clara County,
      California. The user agrees said courts have
      personal jurisdiction and agree to waive any
      right to transfer the dispute to any other forum.
    2. Modification by Unicode. Unicode shall have the
      right to modify this Agreement at any time by
      posting it to this site. The user may not assign
      any part of this Agreement without Unicode's
      prior written consent.
    3. Taxes. The user agrees to pay any taxes
      arising from access to this website or use of
      the information herein, except for those based
      on Unicode's net income.
    4. Severability. If any provision of this Agreement
      is declared invalid or unenforceable, the
      remaining provisions of this Agreement shall
      remain in effect.
    5. Entire Agreement. This Agreement constitutes
      the entire agreement between the parties.

                              EXHIBIT 1
UNICODE, INC. LICENSE AGREEMENT - DATA FILES AND SOFTWARE

  Unicode Data Files include all data files under the
  directories http://www.unicode.org/Public/,
  http://www.unicode.org/reports/, and
  http://www.unicode.org/cldr/data/ . Unicode Software
  includes any source code published in the Unicode
  Standard or under the directories http://www.unicode.org
  /Public/, http://www.unicode.org/reports/, and
  http://www.unicode.org/cldr/data/.

  NOTICE TO USER: Carefully read the following legal
  agreement. BY DOWNLOADING, INSTALLING, COPYING
  OR OTHERWISE USING UNICODE INC.'S DATA FILES
  ("DATA FILES"), AND/OR SOFTWARE ("SOFTWARE"),
  YOU UNEQUIVOCALLY ACCEPT, AND AGREE TO BE
  BOUND BY, ALL OF THE TERMS AND CONDITIONS OF
  THIS AGREEMENT. IF YOU DO NOT AGREE, DO NOT
  DOWNLOAD, INSTALL, COPY, DISTRIBUTE OR USE THE
  DATA FILES OR SOFTWARE.

  COPYRIGHT AND PERMISSION NOTICE

Copyright © 1991-2008 Unicode, Inc. All rights reserved.
Distributed under the Terms of Use in
http://www.unicode.org/copyright.html.

Permission is hereby granted, free of charge, to any
person obtaining a copy of the Unicode data files and any
associated documentation (the "Data Files") or Unicode
software and any associated documentation (the
"Software") to deal in the Data Files or Software without
restriction, including without limitation the rights to use,
copy, modify, merge, publish, distribute, and/or sell copies
of the Data Files or Software, and to permit persons to
whom the Data Files or Software are furnished to do so,
provided that (a) the above copyright notice(s) and this
permission notice appear with all copies of the Data Files
or Software, (b) both the above copyright notice(s) and this
permission notice appear in associated documentation,
and (c) there is clear notice in each modified Data File or
in the Software as well as in the documentation
associated with the Data File(s) or Software that the data
or software has been modified.

THE DATA FILES AND SOFTWARE ARE PROVIDED "AS
IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE
WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
PARTICULAR PURPOSE AND NONINFRINGEMENT OF
THIRD PARTY RIGHTS. IN NO EVENT SHALL THE
COPYRIGHT HOLDER OR HOLDERS INCLUDED IN THIS
NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL
INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY
DAMAGES WHATSOEVER RESULTING FROM LOSS OF
USE, DATA OR PROFITS, WHETHER IN AN ACTION OF
CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
ACTION, ARISING OUT OF OR IN CONNECTION WITH
THE USE OR PERFORMANCE OF THE DATA FILES OR
SOFTWARE.

Except as contained in this notice, the name of a copyright
holder shall not be used in advertising or otherwise to
promote the sale, use or other dealings in these Data
Files or Software without prior written authorization of the
copyright holder.

Unicode and the Unicode logo are trademarks of Unicode,
Inc., and may be registered in some jurisdictions. All other
trademarks and registered trademarks mentioned herein
are the property of their respective owners.
Last updated: - Thu 10 Jul 2008 01:56:59 AM CEST