Administrative MySQL Commands

 0    6 fiche    sir
begynn å lære

laste ned mp3 Skriv ut spille sjekk deg selv
 
spørsmålet svaret
This will be used to select a database in the MySQL workarea.
begynn å lære
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
begynn å lære
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
begynn å lære
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
begynn å lære
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
begynn å lære
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
begynn å lære 		Reports details of the MySQL DBMS perfor på engelsk
SHOW TABLE STATUS LIKE tablename\G
Lag flashkort
English

Du må logge inn for å legge inn en kommentar.