Community Member Profile
Yakko Warner
Member since Dec 11, 2008
- Profile: /members/2312-Yakko-Warner.htm
- URL: yakkowarner.blogspot.com
- Comments: 1
- Points: 1
Recent Blog Comments By Yakko Warner
-
Translate Microsoft SQL (MSSQL) To MySQL
Posted on May 30, 2008 at 5:20 PM
For the "drop table if exists", you can use the INFORMATION_SCHEMA schema that is supported in both MSSQL and MySQL: if exists (select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 't_actress') ... I actually came across a recommendation in an article somewhere in Microsoft's ow... read more »
