NYCPHP Meetup

MySQL 4.10 new features ...

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


http://www.mysql.com/newsletter/2003-04/a0000000151.html

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

- Jon

-snip-
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
t1.a=t3.a;
* `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
http://www.mysql.com/doc/en/INSERT.html





More information about the talk mailing list