MSSQL Views and Multiples selects on Mysql
| From: | Jorge Giménez Mayorgas | Date: | Thu, 13 Sep 2001 09:33:51 +0000 |
| Subject: | MSSQL Views and Multiples selects on Mysql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12399@lists.php.net to get a copy of this message | ||
Hi.
I am migrating part of a big database of MSSQL to MySQL . The tables are migrated and data is ok but
I need the views that I used on MSSQL . I tried this , I replaced the name of the view used with the
sql statement , a very big select statement. I have checked SQL syntax with MySQL documentation and
I think it's ok.
It gives me with mysql_errorno the error 1064, any ideas? . Is there any program , script , etc
to migrate to MySQL SQL syntax the views of MSSQL .
Later,
Jorge Gimenez