Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

How to see the records/contents of a MySQL database table?

If you have your own server and have MySQL installed with some database, and would like to view
the contents of a table in that database, then you can follow the steps below:-

Step 1: Login to your Linux server and run the command below on the MySQL command line to login :-
mysql -u root -p [enter]
enter the password

Step 2: View the databases created on the system :-
show databases;

Step 3: Use the database under which you would like to view the contents of the table. For ex-
use abc_db;

Step 4: View the tables in that database using the command below:-
show tables;

Step 5: Now to view the contents of a table, run the command :-
select * from table_a1b2;

After running the command above, you will see the contents of the table.

Sachin Monday 19 August 2013 - 3:11 pm | | Default

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.