Edit database

[rcollins]

I am pretty new at mysql. I have a database that has a corrupt entry that I need to remove. If I open it in VI, it is all scrambled. What do I use to see the tables in my database? Any help would be great. Thanks

[Steve T]

are you asking to see the DATA in a table(1) or a list of tables in a schema(2)?

(1) use the MySQL Query Browser

(2) there is a db schema called "information_sc hema" the tables inside are the meta data of the different databases. The TABLES table will tell you all the tables for a givine schema ( select * from infromation_sch ema.tables where table_schema = "<your schema name>"

[ronverdonk]

When you want to see the tables in your db, simply use the

SHOW TABLES

command.

Ronald :cool: