Administrative MySQL Commands

 0    6 schede    sir
inizia ad imparare

Scarica mp3 Stampa Gioca Testa il tuo livello
 
Domanda Risposta
This will be used to select a database in the MySQL workarea.
inizia ad imparare
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
inizia ad imparare
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
inizia ad imparare
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
inizia ad imparare
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
inizia ad imparare
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
inizia ad imparare 		Reports details of the MySQL DBMS perfor in inglese
SHOW TABLE STATUS LIKE tablename\G
Crea delle schede
English

Devi essere accedere per pubblicare un commento.