Version 3.x tables with a new 4.0.x engine

[Yrjö Mäenpää]

Hi

Can I expect newly upgraded MySQL 4.0.1x engine to
read my old version 3.x tables without trouble, so I can
optimize them after I have installed the the new engine.

I am using MyISAM tables in both systems.

thanks


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Any way to make a "top ten" query?

[Yrjö Mäenpää]

As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to make"top ten" type of a query , i.e. to
select ten best selling products or ten highest mountains for example.

thanks



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php