SpirirHost Support Centre: MySQL Reference Manual p.102

<< 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

102 MySQL Technical Reference for Version 4.0.3 You should use TRUNCATE TABLE when you want to delete all rows from a table and you don't care how many rows were deleted. (Because TRUNCATE TABLE is faster than DELETE FROM table_name). You will get an error if you have an active LOCK TABLES or transaction when trying to execute TRUNCATE TABLE or DROP DATABASE. You should use integers to store values in BIGINT columns (instead of using strings, as you did in MySQL 3.23). Using strings will still work, but using integers is more ecient. Format of SHOW OPEN TABLE has changed. Multi-threaded clients should use mysql_thread_init() and mysql_thread_end(). See Section 8.4.8 [Threaded clients], page 604. If you want to recompile the Perl DBD::mysql module, you must get Msql-Mysql- modules version 1.2218 or newer because the older DBD modules used the deprecated drop_db() call. RAND(seed) returns a dierent random number series in 4.0 than in 3.23; this was done to further dierentiate RAND(seed) and RAND(seed+1). 2.5.2 Upgrading From Version 3.22 to Version 3.23 MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM type. You don't have to convert your old tables to use these with Version 3.23. By default, all new tables will be created with type MyISAM (unless you start mysqld with the --default- table-type=isam option). You can change an ISAM table to a MyISAM table with ALTER TABLE table_name TYPE=MyISAM or the Perl script mysql_convert_table_format. Version 3.22 and 3.21 clients will work without any problems with a Version 3.23 server. The following list tells what you have to watch out for when upgrading to Version 3.23: All tables that use the tis620 character set must be xed with myisamchk -r or REPAIR TABLE. If you do a DROP DATABASE on a symbolic linked database, both the link and the original database are deleted. (This didn't happen in 3.22 because congure didn't detect the readlink system call.) OPTIMIZE TABLE now only works for MyISAM tables. For other table types, you can use ALTER TABLE to optimise the table. During OPTIMIZE TABLE the table is now locked from other threads. The MySQL client mysql is now by default started with the option --no-named- commands (-g). This option can be disabled with --enable-named-commands (-G). This may cause incompatibility problems in some casesfor example, in SQL scripts that use named commands without a semicolon! Long format commands still work from the rst line. Date functions that work on parts of dates (like MONTH()) will now return 0 for 0000- 00-00 dates. (MySQL 3.22 returned NULL.) If you are using the german character sort order, you must repair all your tables with isamchk -r, as we have made some changes in the sort order!

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