GNU Info

(mysql.info)News-4.0.0

---

Prev: News-4.0.x Up: News-4.0.x

---

Enter node , (file) or (file)node

Changes in release 4.0.0
------------------------

   * Multi-table `DELETE'.

   * Don't support old client protocols prior to MySQL 3.21 any more.

   * Don't include the old C API functions `mysql_drop_db',
     `mysql_create_db' and `mysql_connect', unless compiled with
     `USE_OLD_FUNCTIONS'.

   * Renamed `safe_mysqld' to `mysqld_safe'.

   * Allow `IN' as a synonym for `FROM' in `SHOW' commands.

   * `SHOW INDEXES' is now a synonym for `SHOW INDEX'.

   * Added support for symbolic links to `MyISAM' tables. Symlink
     handling is now enabled by default for Windows.

   * `LOAD DATA FROM MASTER' "auto-magically" sets up a slave.

   * A new `HANDLER' interface to `MyISAM' tables.

   * `COUNT(DISTINCT)' is about 30% faster.

   * `FULLTEXT' index creation now is much faster.

   * Searching on packed (`CHAR'/`VARCHAR') keys now is much faster.

   * Added `SQL_CALC_FOUND_ROWS' and `FOUND_ROWS()'. This makes it
     possible to know how many rows a query would have returned without
     a `LIMIT' clause.

   * Changed output format of `SHOW OPEN TABLES'.

   * Allow `SELECT expression LIMIT ...'.

   * Added `IDENTITY' as a synonym for `AUTO_INCREMENT' (like Sybase).

   * Added `ORDER BY' syntax to `UPDATE' and `DELETE'.

   * Optimized queries of type: `SELECT DISTINCT * from table_name
     ORDER by key_part1 LIMIT #'