跳至主要内容

Statements

MySQL statements are the actionable commands that interact with the database. They enable data creation, modification, and control within the database system. Common types of MySQL statements include Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).

Common Uses of MySQL Statements

  1. CREATE Statement: Creates new tables or databases.
  2. INSERT Statement: Adds new data to tables.
  3. UPDATE Statement: Modifies existing data.
  4. DELETE Statement: Removes data from tables.
  5. DROP Statement: Deletes tables or databases.

Examples

  1. CREATE Statement Example
     
    CREATE TABLE customers (id INT, name VARCHAR(50));

    Explanation: Creates a customers table with id and name columns.

  2. INSERT Statement Example
     
    INSERT INTO customers (id, name) VALUES (1, 'John Doe');

    Explanation: Adds a new record to the customers table.

  3. UPDATE Statement Example
     
    UPDATE customers SET name = 'Jane Doe' WHERE id = 1;

    Explanation: Updates the name of the customer with id 1.

  4. DELETE Statement Example
     
    DELETE FROM customers WHERE id = 1;

    Explanation: Deletes the record where id is 1.

  5. DROP Statement Example
     
    DROP TABLE customers;

    Explanation: Deletes the customers table.