Difference between revisions of "MySQL Commands"
Jump to navigation
Jump to search
(Created page with "== Miscellanious MySQL Query Commands == * Login into a MySQL database server from the Linux command line with a user name and have it prompt for the password: <pre style="color:...") |
|||
| Line 10: | Line 10: | ||
* Dislpay all data in a specific table(where table_name is the name of the table you want to use): | * Dislpay all data in a specific table(where table_name is the name of the table you want to use): | ||
<pre style="color:blue">mysql> select * from table_name;</pre><br> | <pre style="color:blue">mysql> select * from table_name;</pre><br> | ||
| − | * Display the number of rows in a | + | * Display the number of rows in a specific table(where table_name is the name of the table you want to count the rows): |
| − | <pre style="color:blue">mysql select count(*) from table_name;</pre><br> | + | <pre style="color:blue">mysql> select count(*) from table_name;</pre><br> |
| − | <br><br> | + | * 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> | ||
| + | * Select rows searching by column name if it's not NULL and display other column data: | ||
| + | (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> | ||
| + | <br> | ||
Revision as of 15:37, 9 June 2013
Miscellanious MySQL Query Commands
- Login into a MySQL database server from the Linux command line with a 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 if it's not NULL and display other column data:
(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;