Additional languages
« 1.6.1 What's New in MySQL 5.1
1.7 MySQL Information Sources »
Section Navigation      [Toggle]

1.6.2. What's Planned for MySQL 5.2

The following features will be added to MySQL 5.2, or change in MySQL 5.2. This section is subject to change as long as MySQL 5.2 development is in its early stages.

The following constructs will become deprecated in MySQL 5.2, or even disappear. Where alternatives are shown, applications should be updated to use them.

  • The table_type variable (use storage_engine)

  • The log_bin_trust_routine_creators variable (use log_bin_trust_function_creators)

  • TIMESTAMP(N): The ability to specify a display width of N (use without N)

  • The TYPE table option to specify the storage engine (use ENGINE)

  • The SHOW TABLE TYPES SQL statement (use SHOW ENGINES)

  • The SHOW INNODB STATUS SQL statement (use SHOW ENGINE INNODB STATUS)

  • The SHOW MUTEX STATUS SQL statement (use SHOW ENGINE INNODB MUTEX)

  • The SHOW LOGS SQL statement

  • The LOAD TABLE FROM MASTER SQL statement

  • The RESTORE TABLE SQL statement

  • The BACKUP TABLE SQL statement