mysql 基本操作

mysql -u username -p

SHOW DATABASES;

CREATE DATABASE database_name;

USE database_name;

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

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE
);

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

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');

SELECT column1, column2, ... FROM table_name WHERE condition;

SELECT * FROM users WHERE name = 'Alice';

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

UPDATE users SET email = 'alice_new@example.com' WHERE name = 'Alice';

DELETE FROM table_name WHERE condition;

DELETE FROM users WHERE name = 'Alice';

DROP TABLE table_name;

DROP DATABASE database_name;