Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Using the MySQL command line

[UrlGuy]

Hi,

I'm starting to learn using the MySQL command line now..
Its in c:\Webroot\MySql\bin\mysql.exe .
First I do
> mysql -u root -p
asks me for password and I enter it.
Then I do "show databases;"
gives me a row of different databases.
Lets say I chose one of them named food with 'use food;'
then I used 'show tables;'
got a list.. of 1000s of different kinds of food.
Then I used 'SELECT * FROM pizza;'
and this showed me a huge list of pizza's.
As this were really hard to read, is there anyway I can output this result of all the pizzas I got into a textfile or similar?
Hope anyone can help, thanks for reading.

[fastduke]

SELECT * INTO OUTFILE 'somepath\somefilename.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM pizza;

[Glosk]

Hi

You can also set mysql to output to a file using \T option like

mysql> \T c:\log.txt

To stop loggin, just do

mysql> \t


Hopes this helps

Glosk