编辑代码

CREATE DATABASE users_db;

-- 使用创建的数据库
USE users_db;

-- 创建用户表
CREATE TABLE users (
    ID INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    action VARCHAR(10) NOT NULL
);

-- 插入一些示例数据
INSERT INTO users (username, password, action) VALUES ('Alex', '1234', 'Delete');
INSERT INTO users (username, password, action) VALUES ('Adam', '12345', 'Delete');
INSERT INTO users (username, password, action) VALUES ('Sara', '123456', 'Delete');
INSERT INTO users (username, password, action) VALUES ('Li', '1234567', 'Delete');