MySQL Commands

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;