mysql

[benG]

Dear all
I have a problem I have a table in mysql with 23 fields. I am writing my commands to Mysql from the MS-DOS command line and when I use the DESCRIBE <table name> command there are so many fields that the first few disappear off the top of the screen.Because it is MS-Dos I cannot scroll the screen back.How can I see the first few fields.....possibly outputting the results of my Describe statement to somewhere...

many thanks

benG

[gofrm]

redirect the output to a file by appending ' > file.txt' to the command.

than you can examine the file with edit.com...

works only, if you pass the query as a parameter to mysql:

i.e.:

mysql -u<login> -p<passwd> -D<database> -e'describe <table>' > test

[benG]

Hello gofrm
thank you for your reply. I think I know what you mean but could you clear up a couple of things for me in your answer....?

In your answer

===========================================

redirect the output to a file by appending ' > file.txt' to the command.

than you can examine the file with edit.com...

works only, if you pass the query as a parameter to mysql:

i.e.:

mysql -u<login> -p<passwd> -D<database> -e'describe <table>' > test

am i right in thinking that you can only do this sort of thing when
you are logging into mysql from the command prompt not from the mysql prompt?

[gofrm]

yes, this works only at the command prompt!

why don't you use phpmyadmin? (www.phpwizard.com)

[benG]

thanks for your help gofrm why don't i use phpwizard?
because I like to make my life hard....!:o

no seriously other people have suggested it...

I just seem to have worked from the MS-DOS command line becuase that is what the book told me!

just one other thing I have discovered a way of outputting to a file from the mysql prompt by using the \T command does the same thing as far as I can see .... is this right?

One last thing to qoute your last answer could you give me an example of what you would actually type

your template answer was

mysql -u<login> -p<passwd> -D<database> -e'describe <table>' > test

from the top...

Whenever I start mysql from the command prompt I type

C:\mysql\bin\mysqld

this produces another prompt whereupon I type

C:\mysql\bin\mysql

At this point I have logged into the Mysql monitor

I haven't set up any users or passwords or anything like that so as you can see there is no -u or -p in my typing

From my manner of logging on if I were to go straight to a specific database eg.store1 on logging on I would type

C:\mysql\bin\mysql < store1

this works fine

however if I type

C:\mysql\bin\mysql < -d store1

a whole load of stuff goes past and I am not logged on
what is going on?

given your template answer

mysql -u<login> -p<passwd> -D<database> -e'describe <table>' > test

could you please tell me what to type exactly

i tried the following but it did not work

C:\mysql\bin\mysql < store1 'describe table1' > outputfile.txt

taking my example names eg. database... store1
table ..........table1
and output file is.....outputfile.txt

could you please tell me exactly what I should type
and i shall bother you no more!

seriously though I am very grateful for your help

benG