What are some of the common MySQL commands?

In MySQL, several commonly used commands facilitate database management, data querying, modification, and optimization. Below are some common categories of MySQL commands with specific examples:

1. Database Operation Commands

• Create Database

  sql
  CREATE DATABASE database_name;

  For example:

  sql
  CREATE DATABASE SchoolDB;

• Drop Database

  sql
  DROP DATABASE database_name;

  For example:

  sql
  DROP DATABASE SchoolDB;

• Use Database

  sql
  USE database_name;

  For example:

  sql
  USE SchoolDB;

2. Table Operation Commands

• Create Table

  sql
  CREATE TABLE table_name (
      column1 data_type,
      column2 data_type,
      ...
  );

  For example:

  sql
  CREATE TABLE Students (
      ID INT,
      Name VARCHAR(100),
      Age INT
  );

• Drop Table

  sql
  DROP TABLE table_name;

  For example:

  sql
  DROP TABLE Students;

• Show Tables

  sql
  SHOW TABLES;

3. Data Manipulation Commands

• Insert Data

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

  For example:

  sql
  INSERT INTO Students (ID, Name, Age) VALUES (1, 'Alice', 21);

• Update Data

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

  For example:

  sql
  UPDATE Students SET Name = 'Bob' WHERE ID = 1;

• Delete Data

  sql
  DELETE FROM table_name WHERE condition;

  For example:

  sql
  DELETE FROM Students WHERE ID = 1;

4. Query Commands

• Simple Query

  sql
  SELECT * FROM table_name;

  For example:

  sql
  SELECT * FROM Students;

• Conditional Query

  sql
  SELECT column1, column2 FROM table_name WHERE condition;

  For example:

  sql
  SELECT Name, Age FROM Students WHERE Age > 18;

5. Permission Management

• Grant Permissions

  sql
  GRANT privileges ON database.table TO 'username'@'hostname';

  For example:

  sql
  GRANT SELECT, INSERT ON SchoolDB.Students TO 'user'@'%';

• Revoke Permissions

  sql
  REVOKE privileges ON database.table FROM 'username'@'hostname';

  For example:

  sql
  REVOKE ALL ON SchoolDB.Students FROM 'user'@'%';

These commands form the core of daily MySQL usage, enabling basic operations and maintenance tasks. For developers and database administrators, mastering these commands is essential.