MySQL解释器

CREATE DATABASE geek_docs;

Query OK, 1 row affected

USE geek_docs;
CREATE TABLE articles (
    id INT PRIMARY KEY,
    title VARCHAR(100),
    content TEXT
);

Query OK, 0 rows affected

INSERT INTO articles (id, title, content) VALUES (1, 'MySQL解释器', 'MySQL解释器负责解释和执行SQL语句');
INSERT INTO articles (id, title, content) VALUES (2, 'MySQL优化器', 'MySQL优化器用于优化查询性能');

Query OK, 1 row affected
Query OK, 1 row affected

SELECT * FROM articles;

+----+---------------+-------------------------------------------+
| id | title         | content                                   |
+----+---------------+-------------------------------------------+
| 1  | MySQL解释器  | MySQL解释器负责解释和执行SQL语句              |
| 2  | MySQL优化器  | MySQL优化器用于优化查询性能                  |
+----+---------------+-------------------------------------------+

UPDATE articles SET title = 'MySQL解释器详解' WHERE id = 1;

Query OK, 1 row affected

DELETE FROM articles WHERE id = 2;

Query OK, 1 row affected