Administrative MySQL Commands

 0    6 fiche    sir
Télécharger mP3 Imprimer jouer consultez
 
question réponse
This will be used to select a database in the MySQL workarea.
commencer à apprendre
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
commencer à apprendre
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
commencer à apprendre
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
commencer à apprendre
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
commencer à apprendre
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
commencer à apprendre
Reports details of the MySQL DBMS perfor Anglais
SHOW TABLE STATUS LIKE tablename\G

Vous devez vous connecter pour poster un commentaire.