Extracting table info from script

[Brandon Jaeger]

Is there a way to extract all of the table information from a script? I have a fairly large script and I need to get all of the row names and stuff from it.

 

Thanks in advance!

 

---brandon

[Guest prozente]

The only way to get it from the script is to go through the script. If you want to get the information from the database then this is much simpler.

 

Assuming this is MySQL you would open the mysql utility

mysql -u database_username -p

It will prompt you for the password, enter it and then it will connect the the MySQL daemon

 

Then you'd select the database you want to look at

Use database_name;

 

Now you can show the tables in the database

Show tables;

 

Now that you know the table names you can look at each table, too see the different fields and the field types you can use

Describe table_name;

 

If you want to see the query used to create the table you would do

Show create table table_name;