Using Table-Related SHOW Statements : Show « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. Show

Using Table-Related SHOW Statements

        
mysql>
SHOW [FULL] COLUMNS FROM <table name> [FROM <database name>] [LIKE '<value>']
mysql>
mysql> SHOW COLUMNS FROM user FROM mysql LIKE '%priv';
+-----------------------+---------------+------+-----+---------+-------+
| Field                 | Type          | Null | Key | Default | Extra |
+-----------------------+---------------+------+-----+---------+-------+
| Select_priv           | enum('N','Y') | NO   |     | N       |       |
| Insert_priv           | enum('N','Y') | NO   |     | N       |       |
| Update_priv           | enum('N','Y') | NO   |     | N       |       |
| Delete_priv           | enum('N','Y') | NO   |     | N       |       |
| Create_priv           | enum('N','Y') | NO   |     | N       |       |
| Drop_priv             | enum('N','Y') | NO   |     | N       |       |
| Reload_priv           | enum('N','Y') | NO   |     | N       |       |
| Shutdown_priv         | enum('N','Y') | NO   |     | N       |       |
| Process_priv          | enum('N','Y') | NO   |     | N       |       |
| File_priv             | enum('N','Y') | NO   |     | N       |       |
| Grant_priv            | enum('N','Y') | NO   |     | N       |       |
| References_priv       | enum('N','Y') | NO   |     | N       |       |
| Index_priv            | enum('N','Y') | NO   |     | N       |       |
| Alter_priv            | enum('N','Y') | NO   |     | N       |       |
| Show_db_priv          | enum('N','Y') | NO   |     | N       |       |
| Super_priv            | enum('N','Y') | NO   |     | N       |       |
| Create_tmp_table_priv | enum('N','Y') | NO   |     | N       |       |
| Lock_tables_priv      | enum('N','Y') | NO   |     | N       |       |
| Execute_priv          | enum('N','Y') | NO   |     | N       |       |
| Repl_slave_priv       | enum('N','Y') | NO   |     | N       |       |
| Repl_client_priv      | enum('N','Y') | NO   |     | N       |       |
| Create_view_priv      | enum('N','Y') | NO   |     | N       |       |
| Show_view_priv        | enum('N','Y') | NO   |     | N       |       |
| Create_routine_priv   | enum('N','Y') | NO   |     | N       |       |
| Alter_routine_priv    | enum('N','Y') | NO   |     | N       |       |
| Create_user_priv      | enum('N','Y') | NO   |     | N       |       |
| Event_priv            | enum('N','Y') | NO   |     | N       |       |
| Trigger_priv          | enum('N','Y') | NO   |     | N       |       |
+-----------------------+---------------+------+-----+---------+-------+
28 rows in set (0.01 sec)

mysql>








Related examples in the same category

1.Determine which functions the running version of MySQL supports with the SQL command SHOW VARIABLES.
2.Determine the computer's time zone with SHOW_VARIABLES
3.The SHOW INDEX statement
4.SHOW CREATE TABLE
5.SHOW TABLES with LIKE clause
6.Ask the server to report the number of connections it's received and its uptime
7.Using SHOW and DESCRIBE to Review Table Structures
8.Returns information about all indexes of the table
9.Show columns command
10.Using the SHOW CREATE TABLE statement
11.Using the SHOW VARIABLES Statement to Retrieve Server System Variable Settings
12.Returning now to the syntax, you can see that a basic SHOW STATUS statement is very straightforward
13.SHOW STATUS statement returns all those status variables whose name contains the string select:
14.Have the root user show the change.
15.Using Show Create Table command to check table
16.SHOW COLUMNS
17.To find out the current type of a table, use the SHOW TABLE STATUS statement or SHOW CREATE TABLE
18.SHOW CREATE TABLE tableName\G
19.Using Database-Related SHOW Statements
20.SHOW DATABASE statement
21.This SHOW statement returns more than these columns
22.Add a LIKE clause at the end of a SHOW statement to display information only for column names that match a given pattern
23.To determine the tables a particular database contains, use SHOW TABLES:
24.SHOW DATABASES and SHOW TABLES can each take a LIKE 'pattern' clause
25.Using the SUM function, make a report that shows the total sales numbers in each quarter.
26.Show warnings
27.Show status for a procedure
28.Show create procedure
29.Specify a value in the LIKE clause that includes the string query
30.Listing Existing Tables in a Database with SHOW TABLES
31.Returns a list of all databases
32.Testing Whether a Database Exists
33.Listing Database or Table Names
34.The _ character means "match any character" in pattern strings
35.Determining Existing SPs
36.Monitoring the MySQL Server
37.get the thread identity
38.Returns a list of all tables in dbname
39.Testing Whether a Table Exists
40.Getting Table Structure Information