Difference between revisions of "MySQL Commands"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
* Display column names of a table(where table_name is the name of the table you want to use): | * Display column names of a table(where table_name is the name of the table you want to use): | ||
<pre style="color:blue">mysql> describe table_name;</pre><br> | <pre style="color:blue">mysql> describe table_name;</pre><br> | ||
| − | * Select rows searching by column name if it's not NULL and display other column data: | + | * 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) | (This example uses one of my actual databases for the table name and column names) | ||
<pre style="color:blue">mysql> select realname,location from dawg_users where location is not null;</pre><br> | <pre style="color:blue">mysql> select realname,location from dawg_users where location is not null;</pre><br> | ||
<br> | <br> | ||
Revision as of 15:51, 9 June 2013
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:
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;