Finding out if a Mysql database contains a certain table

[ngw]

Hi *,
I need to find out if a MySQL db contains a certain table, if not I have
to create it.
I'm using the SHOW TABLES instruction that returns a Mysql::Result
object, but after that I'm stuck, I don't know how to process the
resultset without writing awful code
I mean, I can resolve the problem by using a "state" variable inside a
block and turn it to true if it finds the table, but I guess there's a
more appropriate way to handle this kind of problems.

result = dbh.query("SELECT * FROM album")
foo = false
result.each {|row| foo = true if row.include?("Killing Joke")}
if foo == true
puts "HA!"
end
result.free

This is the code I have now, UGH !

TIA,
ngw

 

[Caleb Tennis]

Hi *,
I need to find out if a MySQL db contains a certain table, if not I
have
to create it.
I'm using the SHOW TABLES instruction that returns a Mysql::Result
object, but after that I'm stuck, I don't know how to process the
resultset without writing awful code
I mean, I can resolve the problem by using a "state" variable inside a
block and turn it to true if it finds the table, but I guess there's a
more appropriate way to handle this kind of problems.

A show tables command just returns a query of table names, 1 per row.

I'm not sure if you need to do something more complex, but in MySQL
it's valid to do:

CREATE TABLE IF NOT EXISTS

Caleb

 

[David Vallner]

D=C5=88a Nede=C4=BEa 19 Febru=C3=A1r 2006 18:31 Caleb Tennis nap=C3=ADsal:

A show tables command just returns a query of table names, 1 per row.

Sidenote: SHOW TABLES is a MySQLism, so watch out it you can't rule out the=
=20
data will be migrated to another DB.

David Vallner