MySQL Command to display rows of a table.

[Akino877]

Hello,

Does anyone know of a MySQL command that would display rows (or contents) of a table? I can write a Perl script to do this. But I wonder if there is a way to use MySQL command to achieve the same thing without writing a Perl or PHP program?

Thank you,

Akino

[chaarmann]

Hello,

Does anyone know of a MySQL command that would display rows (or contents) of a table? I can write a Perl script to do this. But I wonder if there is a way to use MySQL command to achieve the same thing without writing a Perl or PHP program?

Thank you,

Akino

You can use any programming language to do that (JSP, Java, Basic, C++, ..).
You can also use GUI tools like TOAD, SQLYog,... to get the results.

The principle is easy: you just connect to the database and then execute the SQL-command. It's not dependent on the language (perl,php) or tools your are using.

In fact, you don't need any tools installed.
You can use your shell-window (MS-DOS-command line) (open it by start->run->cmd) on Windows. Then change to your mySQL-bin directory with "cd" command. Now type "mysql -u root -p" to connect to your mySql server and then type your SQL command to display the table data. (if you are not root user, change "root" to your username)

For a more elaborate description, see your mySql user manual, chapter "tutorial", section "connection to the server" and "Entering queries".

[ronverdonk]

Hello,

Does anyone know of a MySQL command that would display rows (or contents) of a table? I can write a Perl script to do this. But I wonder if there is a way to use MySQL command to achieve the same thing without writing a Perl or PHP program?

Thank you,

Akino

Just curious: and how do you want to issue that table display command to MySQL? Program, manually?

Ronald