MySQL Common commands

SHOW databases returns a list of available databases, which may be included in the MySQL database for internal use (such as MySQL and Information_schema)

SHOW TABLES
Returns a list of tables within a database

SHOW COLUMNS from Customers,describe Customer
Returning table columns

SHOW CREATE TABLE Test1

Show table status like ' test1% '

CREATE TABLE Customer
(
ID int NOT NULL Primary key auto_increment,
Name varchar (50),
Age int
)

ALTER TABLE Customer engine= ' Myisam ' changes the ENGINE

SHOW TABLE STATUS like ' Customer '

Show status Displays server state information

Show grants to display the security permissions granted to a user

Show ERRORS show warnings used to display server error and warning messages

MySQL Common commands