Hi, Waiting for v5 for views, you can prepare them in inline view (subqueries):
select ... from (select ...) Mathias Selon Duncan Hill <[EMAIL PROTECTED]>: > On Monday 23 May 2005 20:01, Dayakar wrote: > > Please give me solutions at the earliest as mirgration from oracle to mysql > > is started and i need to meet the solution as soon as possible. > > 4.1 does not support views. As documented in the online documentation: > "Views (including updatable views) are implemented in the 5.0 version of > MySQL > Server. Views are available in binary releases from 5.0.1 and up. See Chapter > 21, Views." > > Migrating, and then reading the documentation and trying to learn how things > work is usually a bad idea. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]