Shiny New MySQL - Current and forthcoming
MySQL version 4.0 has been suitable for production use since March 2003. The previous version is no longer under development. In today's article we will be looking at the shiny new features that you have to play with in version 4.0. Allan doesn't just give you a big list of the changes with no explanation; he explains why the major changes will make your job easier, make you richer and more popular with members of the opposite sex.
Then Allan examines the proposed changes in MySQL 4.1 and 5.0
This article explains
- why MySQL 4 is an 'ACID' database
- FULLTEXT searches
- SQL_CALC_FOUND_ROWS and FOUND_ROWS() functions
- Sub-queries
- The UNION statement
- how MySQL becomes faster
Overview
Table of Content:
- MySQL 4.0
- MySQL 4.0 is an ACID database
- InnoDB Tables
- Internationalisation
- New features and enhancements
- FULLTEXT Searches
- Usability
- Standards Compliance
- Oracle and Sybase migratee loveliness
- Native support on Netware
- Embedded MySQL
- MySQL on Speed
- MySQL 4.1
- Sub-queries
- Internationalisation
- New features and enhancements
- MySQL 4.1 risk of SQL Injection hacks
- "To MySQL 5.0 and beyond!"
- Executive Summary
Allan comes from Cape Town, South Africa. He has been implicated in writing for several WROX, glasshaus, Wiley and Apress publications, generally in the 'cool stuff that PHP can do' sections.
You can catch up with him at his website http://www.mediafrenzy.co.za.
See All Postings From Allan Kent >>
Reviews
Be the first to write a review
You must me logged in to write a review.