Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: can mysql do derived tables?

    Hi all,

    I'm new to mysql, so any help would be appreciated.

    My problem arised when I was given this project where I have to convert a set of schemas from MS Sql to MySql.
    As I just found out MySql does not support the implementation of "VIEW", I was wondering if there is a way to get around it?

    The obvious thing I thought was to simply embed all the statements.
    But how do I do that? Can I do that in MySql?

    If anyone has done this before, please help out. I can post some sample code here if it helps.


  2. #2
    Join Date
    Oct 2003

    Red face

    Before you proceed too far, make certain that MySQL supports all of the things your application will require. Microsoft (nee Sybase) SQL is designed to be a more full-featured implementation than MySQL is designed to be. Be certain that the lack of views is not merely the first "gotcha." There are other choices out there, if need be.
    ChimneySweep(R): fast, automatic
    table repair at a click of the

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts