Administrative MySQL Commands

 0    6 flashcards    sir
start learning

download mp3 print play test yourself
 
Question Answer
This will be used to select a database in the MySQL workarea.
start learning
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
start learning
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
start learning
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
start learning
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
start learning
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
start learning 		Reports details of the MySQL DBMS perfor in English
SHOW TABLE STATUS LIKE tablename\G
Create flashcards
English

You must sign in to write a comment