Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Certification Obtaining database MetaData

MySQL Certification Obtaining database MetaData

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
28 cards
()
Section 1

Preview this deck

TABLES

Front

1 / 28

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (28)

Section 1

(28 cards)

TABLES

Front

What informationSchema table returns info about Tables

Back

SHOW DATABASES SHOW TABLES SHOW COLUMNS

Front

Which show statements can have a like clause

Back

ROUTINES

Front

What informationSchema table returns info about stored procs and functions

Back

SHOW Databases [WHERE condition>;

Front

What is the syntax to show databases with the show command?

Back

COLLATIONS

Front

What informationSchema table returns info about collations for each character set

Back

COLLATION_CHARACTER_SET_APPLICABILITY

Front

What informationSchema table returns info about which character set applies to each collation

Back

SELECT attributes FROM INFORMATIONSCHEMA.table WHERE condition

Front

What is the Select statement to get meta data information

Back

STATISTICS

Front

What informationSchema table returns info about table indexes

Back

VIEWS

Front

What informationSchema table returns info about Views in the database

Back

SHOW [FULL] COLUMNS FROM table [WHERE condition> or SHOW [FULL] FIELDS FROM table [WHERE condition>

Front

What is the format of show to output column for a table

Back

SCHEMA_PRIVILEGES

Front

What informationSchema table returns info about character sets

Back

COLUMN_PRIVILEGES

Front

What informationSchema table returns info about column privileges by user accounts

Back

CHARACTER_SETS

Front

What informationSchema table returns info about character sets

Back

COLUMNS

Front

What informationSchema table returns info about table columns

Back

USER_PRIVILEGES

Front

What informationSchema table returns info about global privileges held by users

Back

SHOW KEYS FROM table [WHERE condition> or SHOW INDEX FROM table [WHERE condition>

Front

What is the format of show to output keys for a table

Back

KEY_COLUMN_USAGE

Front

What informationSchema table returns info about constraints on key columns

Back

SHOW CHARACTER SET; SHOW COLLATION;

Front

What is the syntax to show Character sets and collation?

Back

False an error will occur.

Front

InformationSchema tables can be modified with INSERT, DELETE, and UPDATE

Back

DESCRIBE table;

Front

Use describe to show table information.

Back

TRIGGERS

Front

What informationSchema table returns info about triggers

Back

mysqlshow [options] [db_name [table_name [column_name]]]

Front

What is the syntax for the mysqlshow program.

Back

mysqlshow --keys d1 t1

Front

Use the keys option to show indexes for table t1 in database d1

Back

SCHEMATA

Front

What informationSchema table returns info about databases

Back

SHOW Tables [FROM database] [WHERE condition>

Front

What is the format of Show used to output the tables in a database.

Back

TABLE_PRIVILEGES

Front

What informationSchema table returns info about table privleges held by user accounts

Back

TABLE_CONSTRAINTS

Front

What informationSchema table returns info about table constraints

Back

Databases

Front

When given no arguments what does mysqlshow display

Back