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.