MySQL™: The World’s Most Popular Open Source Database 163 MySQL 4.1 • Features – Subqueries / nested SELECTs • SELECT row1 FROM table1 WHERE a=(SELECT b FROM table2) – GIS / Geometric Data – Warnings when data is lost – Unicode support – Memory tables • SELECT * FROM table1, (SELECT b from table2) WHERE ... – Multiple table update • UPDATE t1,t2,t3 SET t1.c1=Val,t2.c2=val2 WHERE t1.id=t2.id and t2.id=t3.id – Others: SSL Copyright 2003 MySQL AB