MySQL 4.10 new features ...

Jon Baer jonbaer at
Tue Apr 29 16:34:17 EDT 2003

Just thought Id pass that URL along to anyone that wasn't subscribed to the
newsletter ...

- Jon

Some new features include:

* Subqueries:
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: SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE
* `INSERT ... ON DUPLICATE KEY UPDATE ...' syntax. This allows you to
`UPDATE' an existing row if the insert would cause a duplicate value in a
`PRIMARY' or `UNIQUE' key. (`REPLACE' allows you to overwrite an existing
row, which is something entirely different. See

More information about the talk mailing list