MySQL Commands in English

What is the command to create a new database in MySQL?

• ADD DATABASE database_name;

• CREATE DATABASE database_name;

• CREATE TABLE database_name;

• INSERT INTO database_name;

How do you display all databases in MySQL?

• DISPLAY DATABASES;

• LIST DATABASES;

• VIEW DATABASES;

• SHOW DATABASES;

What is the command to create a new table in MySQL?

• ADD TABLE table_name (column1 datatype, column2 datatype, ...);

• INSERT INTO table_name (column1 datatype, column2 datatype, ...);

• CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

• CREATE NEW table_name (column1 datatype, column2 datatype, ...);

How do you show the structure of a table in MySQL?

• DESCRIBE users;

• SHOW TABLE users;

• VIEW users;

• DISPLAY users;

What is the command to insert data into a table in MySQL?

• INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

• INSERT INTO table_name VALUES (value1, value2, ...);

• ADD INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

• INSERT table_name (column1, column2, ...) VALUES (value1, value2, ...);

How do you update data in a table in MySQL?

• UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

• CHANGE table_name SET column1 = value1, column2 = value2 WHERE condition;

• INSERT INTO table_name VALUES (value1, value2);

• MODIFY table_name SET column1 = value1, column2 = value2 WHERE condition;

What is the command to delete a table in MySQL?

• REMOVE TABLE table_name;

• DROP TABLE table_name;

• DROP DATABASE table_name;

• DELETE TABLE table_name;

How do you delete a database in MySQL?

• ERASE DATABASE mydatabase;

• DROP DATABASE mydatabase;

• REMOVE DATABASE mydatabase;

• DELETE DATABASE mydatabase;

What is the command to grant privileges in MySQL?

• CREATE

• ALLOW

• PERMIT

• GRANT

How do you revoke privileges in MySQL?

• REVOKE privilege_type ON database_name.table_name TO 'username'@'host';

• REVOKE privilege_type ON database_name.table_name FROM 'username'@'host';

• REVOKE privilege_type FROM 'username';

• REVOKE privilege_type FROM 'username'@'host';