view table contents from telnet

hinchdog · Jan 8, 2002

is there a way to see the table contents -- meaning the data within each row -- from the telnet consol?

Broccoli2 · Jan 9, 2002

Can you run

Code:

mysqld

? If so, use it to enter SQL commands directly to the server.

-Rob

Broccoli2 · Jan 9, 2002

Oops I mean

Code:

mysql

- the native MySQL console ...

Sorry for the typo

-Rob

hinchdog · Jan 9, 2002

how to you run this?

Broccoli2 · Jan 9, 2002

Try just typing

Code:

mysql

. If your shell doesn't recognise the command, then you need to change to the

Code:

bin

subdirectory where you installed MySQL (on Windows try

Code:

C:\mysql

or

Code:

C:\Program Files\mysql

- on Linux/Unix try

Code:

/usr/local/mysql

).

Once you've found the

Code:

mysql

binary you can use it to connect to your server. This is described on

If you post any errors you get that will help identify any problems.

-Rob