SpirirHost Support Centre: MySQL Reference Manual p.103

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 103 The default return type of IF will now depend on both arguments and not only the rst argument. AUTO_INCREMENT will not work with negative numbers. The reason for this is that negative numbers caused problems when wrapping from -1 to 0. AUTO_INCREMENT for MyISAM tables is no handled at a lower level and is much faster than before. For MyISAM tables old numbers are also not reused anymore, even if you delete some rows from the table. CASE, DELAYED, ELSE, END, FULLTEXT, INNER, RIGHT, THEN, and WHEN are now reserved words. FLOAT(X) is now a true oating-point type and not a value with a xed number of decimals. When declaring DECIMAL(length,dec) the length argument no longer includes a place for the sign or the decimal point. A TIME string must now be of one of the following formats: [[[DAYS] [H]H:]MM:]SS[. or [[[[[H]H]H]H]MM]SS[.fraction]. LIKE now compares strings using the same character comparison rules as =. If you require the old behaviour, you can compile MySQL with the CXXFLAGS=-DLIKE_CMP_ TOUPPER ag. REGEXP is now case-insensitive for normal (not binary) strings. When you check/repair tables you should use CHECK TABLE or myisamchk for MyISAM tables (`.MYI') and isamchk for ISAM (`.ISM') tables. If you want your mysqldump les to be compatible between MySQL Version 3.22 and Version 3.23, you should not use the --opt or --full option to mysqldump. Check all your calls to DATE_FORMAT() to make sure there is a `%' before each format character. (MySQL Version 3.22 and later already allowed this syntax.) mysql_fetch_fields_direct is now a function (it was a macro) and it returns a pointer to a MYSQL_FIELD instead of a MYSQL_FIELD. mysql_num_fields() can no longer be used on a MYSQL* object (it's now a function that takes MYSQL_RES* as an argument, so you should use mysql_field_count() instead). In MySQL Version 3.22, the output of SELECT DISTINCT ... was almost always sorted. In Version 3.23, you must use GROUP BY or ORDER BY to obtain sorted output. SUM() now returns NULL, instead of 0, if there are no matching rows. This is according to ANSI SQL. An AND or OR with NULL values will now return NULL instead of 0. This mostly aects queries that use NOT on an AND/OR expression as NOT NULL = NULL. LPAD() and RPAD() will shorten the result string if it's longer than the length argument. 2.5.3 Upgrading from Version 3.21 to Version 3.22 Nothing that aects compatibility has changed between versions 3.21 and 3.22. The only pitfall is that new tables that are created with DATE type columns will use the new way to store the date. You can't access these new elds from an old version of mysqld.

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide