On Thursday 06 October 2005 10:57 am, Ryan Stille wrote: > I am converting some code from MSSQL to MySQL. In one place I need to > have a conditional query depending on if a table exists or not. There > are different versions of this application and the table only exists in > some of them. Here is how it was done in MSSQL: > > IF OBJECT_ID('cfgbiz') IS NOT NULL > SELECT notifyto FROM cfgbiz > ELSE > SELECT '' as notifyto > > Is there something similar in MySQL? I am running version 4.1.x.
5.X has information_schema.. However... 4.1, you can show tables like '%tab%' and you will get a row back if exists.. WARNING, myisam will be quick, innodb will be really slow, specially if the tables are big.. Jeff
pgphkfOW9sFUY.pgp
Description: PGP signature