Dyntex.net Support Centre: MySQL Reference Manual p.48

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

48 MySQL Technical Reference for Version 4.0.3 Change the format of DATETIME to store fractions of seconds. Add all missing ANSI92 and ODBC 3.0 types. Change table names from empty strings to NULL for calculated columns. Don't use Item_copy_string on numerical values to avoid number->string->number conversion in case of: SELECT COUNT(*)*(id+0) FROM table_name GROUP BY id Make it possible to use the new GNU regexp library instead of the current one (the GNU library should be much faster than the old one). Change so that ALTER TABLE doesn't abort clients that execute INSERT DELAYED. Fix so that when columns are referenced in an UPDATE clause, they contain the old values from before the update started. Add simulation of pread()/pwrite() on Windows to enable concurrent inserts. A logle analyser that could parse out information about which tables are hit most often, how often multi-table joins are executed, etc. It should help users identify areas or table design that could be optimised to execute much more ecient queries. Add SUM(DISTINCT). Add ANY(), EVERY(), and SOME() group functions. In ANSI SQL these work only on boolean columns, but we can extend these to work on any columns/expressions by applying: value == 0 -> FALSE and value <> 0 -> TRUE. Fix that the type for MAX(column) is the same as the column type: mysql> CREATE TABLE t1 (a DATE); mysql> INSERT INTO t1 VALUES (NOW()); mysql> CREATE TABLE t2 SELECT MAX(a) FROM t1; mysql> SHOW COLUMNS FROM t2; Come up with a nice syntax for a statement that will UPDATE the row if it exists and INSERT a new row if the row didn't exist (like REPLACE works with INSERT / DELETE). 1.8.4 Things That Have to be Done Sometime Implement function: get_changed_tables(timeout,table1,table2,...). Change reading through tables to use memmap when possible. Now only compressed tables use memmap. Make the automatic timestamp code nicer. Add timestamps to the update log with SET TIMESTAMP=#;. Use read/write mutex in some places to get more speed. Full foreign key support in for MyISAM tables, probably after the implementation of stored procedures with triggers. Simple views (rst on one table, later on any expression). Automatically close some tables if a table, temporary table, or temporary les gets error 23 (not enough open les). When one nds a eld=#, change all occurrences of eld to #. Now this is only done for some simple cases.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

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