Administrative MySQL Commands

 0    6 词汇卡    sir
开始学习

下载mp3 打印 玩 检查自己
 
问题 答案
This will be used to select a database in the MySQL workarea.
开始学习
USE Databasename
Lists out the databases that are accessible by the MySQL DBMS.
开始学习
SHOW DATABASES
Shows the tables in the database once a database has been selected with the use command.
开始学习
SHOW TABLES
Shows the attributes, types of attributes, key information, whether NULL is permitted, defaults, and other information for a table.
开始学习
SHOW COLUMNS FROM tablename
Presents the details of all indexes on the table, including the PRIMARY KEY.
开始学习
SHOW INDEX FROM tablename
Reports details of the MySQL DBMS performance and statistics.
开始学习 		Reports details of the MySQL DBMS perfor 用英语
SHOW TABLE STATUS LIKE tablename\G
创建词汇卡
English

您必须登录才能发表评论。