Barrapunto

1.6.1 Features Available From MySQL 4.1

The features listed in this section are implemented in MySQL 4.1. Few other features are still planned for MySQL 4.1. See section 1.9.1 New Features Planned For 4.1.

Most new features being coded, such as stored procedures, will be available in MySQL 5.0. See section 1.9.2 New Features Planned For 5.0.

Support for subqueries and derived tables

                * Subqueries are now supported. Here is an example:

SELECT * FROM t1 WHERE t1.a=(SELECT t2.b FROM t2);

SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM t2);

                * Derived tables (unnamed views) are now supported. Basically, a derived table is a subquery in the FROM clause of a SELECT statement. Here is an example:

SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;

...