Java: Need to question MySQL whether or not a table is there or not 2

[Plogu101]

Stuck on this I can't find an answer on the forums: it's simple all I need to do is write a statement to ask if the database has a table with a particular name already....
e.g

if (*****TableName = table already in DB)
   {
   statement.executeUpdate("INSERT INTO " + TableName +
               "VALUES (newTableName, rateDate);
  }
  // Else create a new table
  else
  {
   statement.executeUpdate("CREATE TABLE " + newTableName )
               
           }

If any one can help they'll be glad to know that it should be the finishing part of a 4 month personal project....phew

 

[TonyGroves]

The query[tt] SHOW TABLES LIKE 'tablename' [/tt]will return a record for each matching table (one or none in this case).

 

[Plogu101]

Thanks Toni,
That makes sense, but I won't be able to test it until tonight, I'll let you know....

 

[esdee]

or just "select * from your table", and if the appropriate exception ("table does not exist or whatever") is thrown - create the table

------------------------

http://esdeeblog.blogspot.com/

dev at viewmoresoft.com

http://www.viewmoresoft.com

tools for your database