常用命令行操作

SHOW DATABASES;

CREATE DATABASE database_name;

USE database_name;

SHOW TABLES;

CREATE TABLE table_name (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(100),
  age INT
);

DESCRIBE table_name;

SHOW COLUMNS FROM table_name;

INSERT INTO table_name (name, age) VALUES ('Alice', 25);

SELECT * FROM table_name;

SELECT * FROM table_name WHERE age > 20;

UPDATE table_name SET age = 26 WHERE name = 'Alice';

DELETE FROM table_name WHERE name = 'Alice';

DROP TABLE table_name;

DROP DATABASE database_name;

exit;