MySQL Practice

Front

Command to open an existing database:

Back

USE

Front

View structure of table ‘STUDENT’:

Back

DESC STUDENT, DESCRIBE STUDENT

Front

View structure of table ‘STUDENT’:

Back

DESC STUDENT, DESCRIBE STUDENT

Front

Key allowing unique or null values.

Back

Unique

Front

Destroy the table ‘STUDENT’.

Back

DROP TABLE STUDENT

Front

Delete * from empl;

Back

Deletes all tuples.