MySQL Commands

From DawglandWiki
Jump to: navigation, search

Miscellanious MySQL Query Commands

  • Login into a MySQL database server from the Linux command line with your user name and have it prompt for the password:
$ mysql -p

  • Display all available datases(from the mysql> command prompt):
mysql> show databases;

  • Select a database(where database_name is the name of the database you want to use):
mysql> use database_name;

  • Display all tables in a database which has been selected:
mysql> show tables;

  • Dislpay all data in a specific table(where table_name is the name of the table you want to use):
mysql> select * from table_name;

  • Display the number of rows in a specific table(where table_name is the name of the table you want to count the rows):
mysql> select count(*) from table_name;

  • Display column names of a table(where table_name is the name of the table you want to use):
mysql> describe table_name;

  • Select rows searching by column name(location) if it's not NULL(not empty and has a value) and display other column data(display realname & location):

(This example uses one of my actual databases for the table name and column names)

mysql> select realname,location from dawg_users where location is not null;


Personal tools