School Map:
Home / Enroll
$ Student Records; Class
$ News @ LIVE
Tech Radio * Support/FAQ
| Store | FORUMS
Class / Forums / homeroom  |
New Features in MySQL 4.1 |
(#90 2003-02-28 19:53:29) Post Reply |
|
logspirit
|
Finally, MySQL will have SUBSELECTS!!! (called Subqueries) ...in version 4.1 now alpha... they say precompiled binaries will be released soon...
Folks, this is the best thing to happen to MySQL since blobs!!! With subselects, you won't have to write convoluted code just to get data from multiple tables when you need to compare to a sub-grouping !!! This will make MySQL much easier to use - and even faster!!! Now You won't have to use Postgre to do Your data mining and then MySQL to deliver Your web pages!!! Of course, Postgre still has some features MySQL doesn't have. (and vice versa!!!) And with the new Derived Tables, creation of complete data sets will be even easier... I also like the idea of multi-line queries (have not played with any of this yet, and I'm not quite sure how it will work, I guess there will be multiple result sets!!!) And the new create table syntax will make creation of temp tables easy, and fast!!! ........... You can see the other improvements for Yourself: The following is derived from: http://www.mysql.com/doc/en/News-4.1.x.html Subqueries: SELECT * from table1 where table1.a=(SELECT table2.b FROM table2); SELECT * from table1 where (1,2,3) in (SELECT a,b,c from table2); Derived tables: SELECT table1.a from table1, (select * from table2) table3 WHERE table1.a=table3.a; INSERT ... ON DUPLICATE KEY UPDATE syntax. This allows you to UPDATE an existing row if it existed before. (REPLACE allows you to overwrite an existing row, which is a different thing). Unicode (UTF8) support. Character sets can be defined per column, table and database. BTREE index on HEAP tables. Support for GIS (Geometrical data). SHOW WARNINGS; Shows warnings for the last command. Faster binary protocol used with prepared statements. Multi-line queries: You can now issue several queries at once and then read the results in one go. Create Table: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table LIKE table. Now, If I can just get my web host to do the upgrade!!! Oh, well... It's all for future scripts anyway!!! Talk To Ya all again soon... from the swamp in FlorDuh... pleeze let me know if Ya'all 'preciate these little notes!!! - logspirit -
|
|
 View Previous Thread Print This Page |
School Map:
Home / Enroll
$ Student Records; Class
$ News @ LIVE
Tech Radio * Support/FAQ
| Store
Advertising
| Link To Us | Privacy
Copyright 2000-2002 Script School Productions / KMR
Enterprises
No part of this website may be reproduced, copied and/or distributed
in any medium
without express written permission
