Additional New Functionality
In this section, you'll see more highlights of new functionality that will be introduced in MySQL 4.1. This list is not the full list of changes; for that, you can read the actual changelog entries at http://www.mysql.com/doc/en/News-4.1.x.html.
Speed enhancements. As if MySQL weren't fast enough, the developers are always finding ways to make it even faster.
Table creation using LIKE. You can use CREATE TABLE tablename LIKE othertablename to create a new table with the exact structure (but no data) as an existing table.
Usability enhancements, primarily a help system within the MySQL command-line interface. Typing UCASE will provide help for the UCASE() MySQL function, for example.
DATE/DATETIME usage will be changing ...
Get Sams Teach Yourself PHP, MySQL® and Apache All in One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
