Administrative MySQL Commands

 0    6 speciālā zīme    sir
sākt mācīties

lejupielādēt mp3 Drukāt spēlēt pārbaudiet sevi
 
jautājums atbilde
This will be used to select a database in the MySQL workarea.
sākt mācīties
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
sākt mācīties
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
sākt mācīties
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
sākt mācīties
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
sākt mācīties
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
sākt mācīties 		Reports details of the MySQL DBMS perfor angļu valodā
SHOW TABLE STATUS LIKE tablename\G
Izveidojiet flashcards
English

Lai ievietotu komentāru, jums jāpiesakās.