Administrative MySQL Commands

 0    6 Datenblatt    sir
Lernen beginnen

mp3 downloaden Drucken spielen überprüfen
 
Frage Antworten
This will be used to select a database in the MySQL workarea.
Lernen beginnen
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
Lernen beginnen
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
Lernen beginnen
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
Lernen beginnen
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
Lernen beginnen
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
Lernen beginnen 		Reports details of the MySQL DBMS perfor Englisch
SHOW TABLE STATUS LIKE tablename\G
Karteikarten erstellen
English

Sie müssen eingeloggt sein, um einen Kommentar zu schreiben.