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.


Thanks

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.