show databases;

\u information_schema


describe  USER_PRIVILEGES;
select distinct grantee from user_Privileges;

select * from user_Privileges;

 select distinct TABLE_SCHEMA from tables;
+--------------------+
| TABLE_SCHEMA       |
+--------------------+
| information_schema | 
| dandrRace          | 
| mysql              | 
+--------------------+

select distinct TABLE_NAME from tables;

+---------------------------------------+
| TABLE_NAME                            |
+---------------------------------------+
| CHARACTER_SETS                        | 
| COLLATIONS                            | 
| COLLATION_CHARACTER_SET_APPLICABILITY | 
| COLUMNS                               | 
| COLUMN_PRIVILEGES                     | 
| ENGINES                               | 
| EVENTS                                | 
| FILES                                 | 
| GLOBAL_STATUS                         | 
| GLOBAL_VARIABLES                      | 
| KEY_COLUMN_USAGE                      | 
| PARTITIONS                            | 
| PLUGINS                               | 
| PROCESSLIST                           | 
| PROFILING                             | 
| REFERENTIAL_CONSTRAINTS               | 
| ROUTINES                              | 
| SCHEMATA                              | 
| SCHEMA_PRIVILEGES                     | 
| SESSION_STATUS                        | 
| SESSION_VARIABLES                     | 
| STATISTICS                            | 
| TABLES                                | 
| TABLE_CONSTRAINTS                     | 
| TABLE_PRIVILEGES                      | 
| TRIGGERS                              | 
| USER_PRIVILEGES                       | 
| VIEWS                                 |
 


| racers                                | 
| columns_priv                          | 
| db                                    | 
| event                                 | 
| func                                  | 
| general_log                           | 
| help_category                         | 
| help_keyword                          | 
| help_relation                         | 
| help_topic                            | 
| host                                  | 
| ndb_binlog_index                      | 
| plugin                                | 
| proc                                  | 
| procs_priv                            | 
| servers                               | 
| slow_log                              | 
| tables_priv                           | 
| time_zone                             | 
| time_zone_leap_second                 | 
| time_zone_name                        | 
| time_zone_transition                  | 
| time_zone_transition_type             | 
| user                                  | 
+---------------------------------------+
describe TABLES; +-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | TABLE_CATALOG | varchar(512) | YES | | NULL | | | TABLE_SCHEMA | varchar(64) | NO | | | | | TABLE_NAME | varchar(64) | NO | | | | | TABLE_TYPE | varchar(64) | NO | | | | | ENGINE | varchar(64) | YES | | NULL | | | VERSION | bigint(21) unsigned | YES | | NULL | | | ROW_FORMAT | varchar(10) | YES | | NULL | | | TABLE_ROWS | bigint(21) unsigned | YES | | NULL | | | AVG_ROW_LENGTH | bigint(21) unsigned | YES | | NULL | | | DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | MAX_DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | INDEX_LENGTH | bigint(21) unsigned | YES | | NULL | | | DATA_FREE | bigint(21) unsigned | YES | | NULL | | | AUTO_INCREMENT | bigint(21) unsigned | YES | | NULL | | | CREATE_TIME | datetime | YES | | NULL | | | UPDATE_TIME | datetime | YES | | NULL | | | CHECK_TIME | datetime | YES | | NULL | | | TABLE_COLLATION | varchar(32) | YES | | NULL | | | CHECKSUM | bigint(21) unsigned | YES | | NULL | | | CREATE_OPTIONS | varchar(255) | YES | | NULL | | | TABLE_COMMENT | varchar(80) | NO | | | | +-----------------+---------------------+------+-----+---------+-------+ select * from tables where table_name ='birdingObservations' ;
TABLE_
CATALOG
TABLE_SCHEMATABLE_NAMETABLE_TYPEENGINEVERSIONROW_FORMATTABLE_
ROWS
AVG_
ROW_
LENGTH
DATA_LENGTHMAX_DATA_LENGTHINDEX_
LENGTH
DATA_
FREE
AUTO_
INCREMENT
CREATE_TIMEUPDATE_TIMECHECK_TIMETABLE_COLLATIONCHECKSUMCREATE_
OPTIONS
TABLE_COMMENT
defrealger1_birdingbirdingObservationsBASE TABLEMyISAM10Dynamic33952548629122814749767106551935360NULL2016-05-11 09:17:422016-05-11 16:11:072016-05-11 09:17:42utf8_unicode_ciNULL
1 row in set (0.08 sec) describe COLUMNS; +--------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+---------------------+------+-----+---------+-------+ | TABLE_CATALOG | varchar(512) | YES | | NULL | | | TABLE_SCHEMA | varchar(64) | NO | | | | | TABLE_NAME | varchar(64) | NO | | | | | COLUMN_NAME | varchar(64) | NO | | | | | ORDINAL_POSITION | bigint(21) unsigned | NO | | 0 | | | COLUMN_DEFAULT | longtext | YES | | NULL | | | IS_NULLABLE | varchar(3) | NO | | | | | DATA_TYPE | varchar(64) | NO | | | | | CHARACTER_MAXIMUM_LENGTH | bigint(21) unsigned | YES | | NULL | | | CHARACTER_OCTET_LENGTH | bigint(21) unsigned | YES | | NULL | | | NUMERIC_PRECISION | bigint(21) unsigned | YES | | NULL | | | NUMERIC_SCALE | bigint(21) unsigned | YES | | NULL | | | CHARACTER_SET_NAME | varchar(32) | YES | | NULL | | | COLLATION_NAME | varchar(32) | YES | | NULL | | | COLUMN_TYPE | longtext | NO | | NULL | | | COLUMN_KEY | varchar(3) | NO | | | | | EXTRA | varchar(27) | NO | | | | | PRIVILEGES | varchar(80) | NO | | | | | COLUMN_COMMENT | varchar(255) | NO | | | | +--------------------------+---------------------+------+-----+---------+-------+ select count(*) from columns where table_name='birdingObservations'; +----------+ | count(*) | +----------+ | 343 | +---------------+------------------+---------------------+-----------------+------------------+---------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+-----------------+-------------+------------+-------+---------------------------------+----------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_ | COLUMN| IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | POSITION | DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | +---------------+------------------+---------------------+-----------------+------------------+---------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+-----------------+-------------+------------+-------+---------------------------------+----------------+ | def | realger1_birding | birdingObservations | submitted | 1 | 0000-00-00 00:00:00 | NO | datetime | NULL | NULL | NULL | NULL | 0 | NULL | NULL | datetime | PRI | | select,insert,update,references | | | def | realger1_birding | birdingObservations | syyyymmddhhmmss | 2 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8 | utf8_unicode_ci | text | | | select,insert,update,references | | | def | realger1_birding | birdingObservations | location | 3 | NULL | YES | varchar | 40 | 120 | NULL | NULL | NULL | utf8 | utf8_unicode_ci | varchar(40) | MUL | | select,insert,update,references | | describe CHARACTER_SETS; describe COLLATIONS; describe COLLATION_CHARACTER_SET_APPLICABILITY; describe COLUMN_PRIVILEGES; describe KEY_COLUMN_USAGE; describe PROFILING; describe ROUTINES; describe SCHEMATA; describe SCHEMA_PRIVILEGES; describe STATISTICS; describe TABLE_CONSTRAINTS; describe TABLE_PRIVILEGES; describe TRIGGERS; describe VIEWS; SELECT ENGINE, TABLE_TYPE, TABLE_NAME, TABLE_SCHEMA, TABLE_CATALOG, MAX_DATA_LENGTH, DATA_LENGTH, AVG_ROW_LENGTH, TABLE_ROWS, ROW_FORMAT, VERSION, DATA_FREE, AUTO_INCREMENT, CREATE_TIME, UPDATE_TIME, CHECK_TIME, TABLE_COLLATION, CHECKSUM, CREATE_OPTIONS, TABLE_COMMENT, DATA_FREE, INDEX_LENGTH FROM TABLES ;